Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Handle content from CSV-file

Author  Topic 

maevr
Posting Yak Master

169 Posts

Posted - 2011-04-04 : 07:54:23
I have three tables with different number of columns and datatypes.
I have a csv-file that contains data for all tables where the first column specifies which table the row belongs to.

One column(TRTYP) in the cvs-file specifies if the actual row is going to be deleted, updated or inserted.

How can I solve this in the best possible way using SSIS and stored procedures via SQL Server 2008?
   

- Advertisement -