December 8, 2015 at 4:13 am
Hi Team,
I scheduled a SQl job with ssis package to run daily.
The ssis package is : Moving the csv data into SQL database every day with the latest csv file available at disk level.
But the data is not overwritten in the destination table ..its just append to the exist data.
1.Could you please let us know how to overwrite in SQL database table ?
2.I want to move 2 csv files data into 2 SQL tables by using single SSIS package ? is it possible to do ?
Thanks,
Lavanya
December 8, 2015 at 4:32 am
If you want to replace the entire table contents then you could simply truncate the table beforehand.
You can import as many files as you wish and move the data to as many tables. The simplest way is to get it working once, with one file and copy the steps within SSIS, so a separate set of steps import each file and move the data. There are more complicated ways to do this -but if it always going to be just two files I would be tempted to keep it as simple as possible.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply