Bulk Insert Task Config (BulK insert CSV file with non-printabe character as field terminator)
I received a CSV file to using 0x1B as the field terminator. I can use the following T-SQL to bulk-insert the data file BULK INSERT MYDB.DBO.TBL_GCMS_CCID_CREDIT_GROUP FROM '\\mySERVER\D$\dataFile.CSV' WITH(BATCHSIZE=50000, DATAFILETYPE= 'char', CHECK_CONSTRAINTS,CODEPAGE='65001',
FIELDTERMINATOR='', rowTERMINATOR='\n') However, the FIELDTERMINATOR value '' is not printable. I would like to know how should I config the Bulk insert task to let the task knwo 0x1B is the field terminator? (Or how to write the bulk insert format file)
Thanks.
May 27th, 2011 6:19am
You could write a scipt component to import the file. See here to read about a script component.
http://msdn.microsoft.com/en-us/library/ms137640.aspx
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2011 8:45am
You could write a scipt component to import the file. See here to read about a script component.
http://msdn.microsoft.com/en-us/library/ms137640.aspx
May 27th, 2011 8:47am
This topic is archived. No further replies will be accepted.
Other recent topics
