Home Forums SQL Server 2008 SQL Server 2008 - General Bulk insert with SQLINT changes int vlaues RE: Bulk insert with SQLINT changes int vlaues
Eirikur Eiriksson
SSC Guru
Points: 182879
More actions
July 31, 2014 at 5:29 am
#1734003
terry999 (7/31/2014)ThanksWhere do I put the -c I triedBULK INSERT tBCP FROM 'C:\temp\tbcp.csv'WITH (FORMATFILE='C:\temp\fmt.fmt', DATAFILETYPE='char')It doesn't work
terry999 (7/31/2014)
Where do I put the -c I tried
BULK INSERT tBCP FROM 'C:\temp\tbcp.csv'
WITH (FORMATFILE='C:\temp\fmt.fmt', DATAFILETYPE='char')
It doesn't work
Ooops, my bad, I was thinking in bcp:-P
Should be DATAFILETYPE = 'char'
😎