1) Foreachfile loop, get the all file name in c:\temp and store in user variable, TestFile.
2) There are 2 files in c:\temp i.e. test1.csv and test2.csv
3) Create Bulk Insert task in Foreachfile loop with source connection to c:\temp\test1.csv and it is running fine.
4) To bulk insert for all files in c:\temp, added Expression for Bulk Insert task where sourceConnection = @[User::TestFile]. Below error is encountered. Please help. THANKS!
The connection "c:\temp\test1.csv" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error at Bulk Insert Task [Bulk Insert Task]: The specified connection "c:\temp\test1.csv" is either not valid, or points to an invalid object. To continue, specify a valid connection.
