asked on

Run SSIS package on another computer

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

Marten Rune

Use a scheduled task to run the pachage on 4.3.2.1

//Marten

ASKER CERTIFIED SOLUTION

Marten Rune

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hungoveragain

ASKER

Can you please be more specific? How do I run a DTSX task in windows scheduler?

Thanks

Mike

hungoveragain

ASKER

Never mind - I have managed it - thanks.

Mike