We help IT Professionals succeed at work.
Get Started

Run SSIS package on another computer

Last Modified: 2013-11-10
I have a problem when trying to run a SSIS package on a remote computer. Let's say I have two computers and

My SQL server instance is on and there is a firewall opening on to an external machine. The SSIS package extracts files from the db, places them on then opens WinSCP to ftp those files to the external machine.

The SSIS package is on \\\d$\somefolder\ssispackage.dtsx

When I run the package on there is no problem with database connectivity or FTP connectivity, however when I set the package to run through the SQL Server Agent and connect to the above file I am told that it can't find WinSCP.

What I am taking this to mean is that is running the SSIS package it finds on, but because WinSCP doesn't exist on it is falling over. While I can install WinSCP on to get this to work it would be pointless because the firewall is closed here.

How can I run the package on, but ensure that it is that is running the package?


Watch Question
SQL Expert/Infrastructure Architect
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE