Saturday, December 6, 2008

Import large file data to sql

Import large file data to sql

Have you tried to use bcp to import the textfile instead of bulkinsert? With bcp you can use a formatfile, and there you can specify exactly how to interpret the incoming raw-data file. See books on line to find out how to use the formatfile. Bcp can be called upon from a stored procedure, and then invoked from the serveragent in case you are worried about how to schedule. I know bcp is not very easy to use, but it is extremely useful.

Best regards


No comments: