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.