Home Forums Data Warehousing Data Transformation Services (DTS) BULK INSERT RE: BULK INSERT

  • 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 = ',') "