March 21, 2011 at 6:29 am
Hi All,
I have flat file more than 1GB. I want to split that 1GB flat file in to multiple chunks using an SSIS package. Please help me out in this to split that flat file.
Srinadh.
March 21, 2011 at 6:39 am
I would add a conditional split to the data flow and split based upon the primary key of the text file , if there is no primary key then you need to find a suitable composite key..
March 21, 2011 at 7:08 am
You could add a row number to the flow, using either a script component or a 3rd party component. Then use a conditional split with some modulo operators to split out the data in several chunks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 23, 2011 at 1:11 am
Adding a conditional split should solve the purpose :cool:.
March 23, 2011 at 1:15 am
juvvipramod (3/23/2011)
Adding a conditional split should solve the purpose :cool:.
No kidding? Exactly the same solution mentioned by the previous two posts...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 23, 2011 at 1:33 am
yeah... right
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply