I have a 2005 SSIS package that I have upgraded to 2008 through the wizard. I am going through it now to correct any issues.
When I review a Data Flow Task Destination, I recieved the following:
"The selected data source is on a remote computer. The bulk insert operation can be executed only on the local computer"
The destination is using OLE DB connection that I have tested in the connection manager. The source's flat file connection manager has a full UNC path and references multiple files (*.txt). I have tested the source's connection by selecting to preview the data and that works.
I have also followed the path and opened one of the text files that would be used by the source connection manager.
Any help would be greatly appreciated.