Home Forums Data Warehousing Data Transformation Services (DTS) BULK INSERT RE: BULK INSERT
Ian Scarlett
SSC-Insane
Points: 23197
More actions
June 25, 2003 at 11:01 am
#463085
You need to use the value of the variable @file to create the dynamic statement i.e.
SET @SQL = "BULK INSERT temp FROM '" + @file1 + "' WITH (FIELDTERMINATOR = ',') "