Load CSV file using BULK with OPENROWSET OPTION
This is a good starting point http://msdn.microsoft.com/en-us/library/ms141239.aspx and followed by http://sqlcat.com/sqlcat/b/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspxPlease vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog
May 17th, 2012 2:42am

HI ALL, I would like to Load CSV file using BULK option with OPENROWSET and also make use of FORMAT XML file, Pls advise Thanks, BB
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2012 2:44am

This is a good starting point http://msdn.microsoft.com/en-us/library/ms141239.aspx and followed by http://sqlcat.com/sqlcat/b/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspxPlease vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog
May 17th, 2012 2:47am

Hello, Check out the blog below. It may help you. http://www.simple-talk.com/sql/reporting-services/using-sql-server-integration-services-to-bulk-load-data/
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2012 4:51am

Hello, Check out the blog below. It may help you. http://www.simple-talk.com/sql/reporting-services/using-sql-server-integration-services-to-bulk-load-data/
May 17th, 2012 4:56am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics