Load 10000 Records into Dynamically Created 100 Files

How to load 10000 records into dynamically created 100 files and to load 100 records in each?

Questions by Rinky   answers by Rinky

Showing Answers 1 - 1 of 1 Answers


  • Sep 11th, 2015

This can be done using TC transformation. In an expression before the TC, keep a counter which increments for each row passed. When the counter reaches 100, reset the counter to 0.
In the expression create a filename port and in the TC write the follwoing: IIF(count=100,TC_COMMIT_BEFORE,TC_CONTINUE_TRANSACTION). In the target create a filename port and connect it.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions