"The selected data source is on remote computer" error when creating an SSIS job

sql-server-2005 ssis import flat-file dataflowtask
Michael Kniskern picture Michael Kniskern · Feb 8, 2011 · Viewed 11.8k times · Source

I am in the process of developing an SSIS job on my workstation which a Data Flow Task open a comma delimited flat file on my local workstation and imports the data to a SQL server database on a remote server.

When I try to select the destination table in my SQL destination object, it gives me the following error:

The selected data source is on a remote computer. The bulk insert operation can be executed on the local computer.

How do I resolve the issue so I can test my SSIS package.

Answer

grapefruitmoon picture grapefruitmoon · Feb 9, 2011

The SQL Server destination only works if the package is running on the same machine as the specified database server. To use remote connections, change to an OleDb destination instead.

Related questions

SSIS 2005: "Append rows to the destination table" is greyed out. Why?

In SQL Server 2005, Import Data (SSIS), my desire is to import a text file and have it append to an existing table. The first time through the wizard on the Column Mappings step I swear the Append rows to the …

Read More
Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type

I have made a dtsx package on my computer using SQL Server 2008. It imports data from a semicolon delimited csv file into a table where all of the field types are NVARCHAR MAX. It works on my computer, but it …

Read More
How do I view the SSIS packages in SQL Server Management Studio?

Argh! I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server using Management Studio. Execute an SSIS package doesn't appear as an option when I go into job scheduler, either.

Read More