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

Anders