the selected datasource is on a remote computer

Last Post 15 Jul 2010 09:27 AM by russellb. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
PaulMcKibben
New Member
New Member

--
14 Jul 2010 11:50 AM

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.



rm
New Member
New Member

--
14 Jul 2010 01:32 PM
Account used in the package has permission on remote files?
PaulMcKibben
New Member
New Member

--
14 Jul 2010 06:24 PM
Yes, in BIDS I am running the package. I have navigated to the folder in question with no issues in Window Explorer while on the server.
russellb
New Member
New Member

--
15 Jul 2010 09:27 AM
do u have a data conversion object between the source and destination in the data flow task?


Acceptable Use Policy
---