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
