Hi. I have tried to following your example posted here verbatim, however, whenever I execute my package it fails on the Execute SQL Task within the Foreach loop. I get the following error
"Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query ""SELECT '"+@[User::FileList]+","+@[User::MissingFi..." failed with the following error: "Incorrect syntax near '+'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Execute SQL Task"
What should I look for that I may have overlooked earlier?
My variables
name datatype value
sql_str String "SELECT '"+@[User::FileList]+", "+@[User::MissingFileName]+'" as FileList"
MissingFiles Object
MissingFileName String
FileList String