May 8, 2011 at 7:31 pm
Hi ,,,
I have one question...??
Here the situation .... I have flat file coming every months.
Files will come every month.
1st file (3/31/2011)
Name country balance
raju UK $50000
keshu USA $5000
2 file (4/30/2010)
Name country balance
raju UK $500
keshu USA $500
Finalily they want
Production database
Name country balance
Raju UK $50000
keshu USA $5000
raju UK $500
keshu USA $500
please let me how to do that ......with ssis ,,,,,,,,,,,,,,,
I am loading file throght SSIS ....so ....
Please help me
THanks
P
May 8, 2011 at 11:32 pm
You have a file...file has records...you have a table...insert data into table...game over!!
Raunak J
May 9, 2011 at 12:02 am
I would advice you to grab a good book on SSIS or find some tutorials online.
Look for the following keywords:
* dataflow
* flat file source
* ole db destination
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 9, 2011 at 5:14 am
Data will duplicate then ???
I have to create composite primary key with date?????
May 9, 2011 at 6:04 am
patla4u (5/9/2011)
Data will duplicate then ???I have to create composite primary key with date?????
The data will duplicate. Just as you described in your question.
If you have one file with 10 rows and another file with 15 rows, you will end up with 25 rows.
To create a column, check out the Derived Column component.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply