We help IT Professionals succeed at work.
Get Started

Run SSIS package on another computer

hungoveragain
on
711 Views
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 1.2.3.4 and 4.3.2.1

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

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

When I run the package on 4.3.2.1 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 1.2.3.4 is running the SSIS package it finds on 4.3.2.1, but because WinSCP doesn't exist on 1.2.3.4 it is falling over. While I can install WinSCP on 1.2.3.4 to get this to work it would be pointless because the firewall is closed here.

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

Thanks

MIke
Comment
Watch Question
SQL Expert/Infrastructure Architect
CERTIFIED EXPERT
Commented:
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