Execute script files and the file path coming from a table

• Charmer

  SSChampion

  Points: 14903

  More actions

  September 10, 2014 at 3:48 am

  #397323

  Hi Friends,

  I have to execute some script files and I am using execute sql task. I used for each loop container to get the file path from the table and assigning it to a variable. But i am not able to execute the script files when I pass the variable to the execute sql task.

  I get this error.

  [Execute SQL Task] Error: Executing the query "S:\Data\Test Folder\A_sample.sq..." failed with the following error: "Incorrect syntax near 'S:'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Please some one tell me how to execute the script files and the path of the file comes from a table...

  Any suggestions would be greatly appreciated.

  Thanks,
  Charmer