bulk insert RRS feed

  • Question

  • Hello,
    The following sql works nicely in query analyser.

    execute BULK INSERT DBName.ssis.tbl1
       FROM 'C:\folderPath\filename.csv';

    p.s. The resultset is set to None

    I am using an execute sql task to run the same sql query bu t the error is:

     [Execute SQL Task] Error: Executing the query "exec BULK INSERT DBName.ssis.tbl..." failed with the following error: "Incorrect syntax near the keyword 'BULK'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Thank you

    Friday, June 24, 2016 4:26 PM


All replies