techEverest
asked on
How to prevent loading same data again into SQL Server destination?
Hi guys,
I am new to SSIS and trying to learn through examples. I recently tried this simple example where I have an OLEDB source and am transferring data to flat file, CSV file and SQL Server destination. I ran this 7-8 times, but everytime I ran it, same data got loaded again and again into SQL Server. First time I ran the package, 115 rows of data got loaded into different destinations. CSV file and flat file didn,t get loaded again after the first package execution.My question are as follows;
1)How do I prevent from loading same old data into SQL Server destination?
2)CSV file has col A n B. col A has string data which spills into colB as shown in the attached file. Some of col B numeric data got pushed to col C. I want all col A and B data in their respective columns.
Thanks
qs1.docx
I am new to SSIS and trying to learn through examples. I recently tried this simple example where I have an OLEDB source and am transferring data to flat file, CSV file and SQL Server destination. I ran this 7-8 times, but everytime I ran it, same data got loaded again and again into SQL Server. First time I ran the package, 115 rows of data got loaded into different destinations. CSV file and flat file didn,t get loaded again after the first package execution.My question are as follows;
1)How do I prevent from loading same old data into SQL Server destination?
2)CSV file has col A n B. col A has string data which spills into colB as shown in the attached file. Some of col B numeric data got pushed to col C. I want all col A and B data in their respective columns.
Thanks
qs1.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the delay. I was away for holiday.Thanks for the quick feedback.