When I deploy my SSIS package to the test server from my production server, I am experiencing an issue with a package I created that uses a For Each loop
I even tried copying the SSIS visual Studio solution and get the same problem.
Oddly enough I do not experience the problem on my development server even when I connect to the SQL server on the test server.
In the For Each Loop container I have a simple Execut SQL task , I am using OLEDB connections
The task simply Deletes records - here is the statement
DELETE FROM Comm
FROM Comm INNER JOIN
Suppliers ON Comm.SupplierID = Suppliers.SupplierID
WHERE (Suppliers.House = ?)
I have the parameter mapping set for the Execut SQL Task to the foreach loop variable
works perfectly on the DEV server but on the test server I get the error
" The multi-part Identifier "Suppliers.House" could not be bound
Schemas are the same, everything is the same except the connection strings
I have attached the .dtsx package for viewing - its added in a zip file with .txt extension - you can change it back to dtsx extension
