Wednesday, January 29, 2014

BCP - Import Date into field type of Date fails

Can you add -V100 like this to see whether it works:



----bcp in with -V100

exec master..xp_cmdshell 'bcp [myDB].[dbo].[A1_bcp] IN "C:\backup\myA1.txt" -T -V100 -c -S myPC\myInstance';

go


No comments:

Post a Comment