May 21, 2010 at 1:22 am
Hi all,
I'm new to SSIS, I've scenario is SSSI,
1) I've country level data (total 14 countries)
2) Transaction table having all countries information
my question is using SSIS package, How can I get 50K records per each country and store it to DB/flat file.
suggest me how can I procced?
May 21, 2010 at 2:45 am
you will need to make your source connection SQL string dynamic, this will allow you to put a where clause with a variable that you ust can select the rows you need you will also need to do something similar to the destination so you can assign the batches to different tables, does the source table have a ID that you can use to select the batches?
May 21, 2010 at 7:08 am
if it is just splitting the data based on the country then you can just use the condition split task which will split the data based on your condition (Country). so the flow will be data flow task containing
1) OLEDB source
2 ) Conditional split with different case for each of the country
3 ) flat file destination/ write into table
if you max cap on the flat file is 50K? then need to think on how to achieve this.
Might be usefull link
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply