Search This Blog

Tuesday, September 1, 2009

Load bcp with Bulk Insert

This is impossible using Google:

BULK INSERT database.dbo.table
FROM 'full_path_name.bcp'
WITH (
DATAFILETYPE = 'native',
KEEPIDENTITY
)

Make sure Full path name is in single quotes.
http://msdn.microsoft.com/en-us/library/ms188365.aspx

No comments: