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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Flexibel csv-Import

Author  Topic 

gpc44
Starting Member

35 Posts

Posted - 2013-07-30 : 16:15:47
Is there a way, to import csv Files with different count of fields (all nvarchar (max)) with one Stored-Procedure in one fix table (with Import-ID) , without having to make much adjustment? The Files are flat Staging csv-Files. Maybe with pivot/unpivot Function etc...
Field and Rowdelimiter are allways the same.

Thank you

Kind Regards
Nicole

   

- Advertisement -