Executing dtsx Package from Remote Machine

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Executing dtsx Package from Remote Machine

Executing dtsx Package from Remote Machine

Rate Topic

Display Mode

Topic Options

Author

Message

amit-1143912

Posted Monday, August 24, 2009 9:40 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 15, 2010 5:49 AM
Points: 32, Visits: 82

HI All,

I have used Application.LoadFromSqlServer() to execute the package in sql server...

When I try this code on the local machine from Dotnet IDE... Package gets executed...

But when I run this same code from remote machine to the same package stored on the previos machine... Package doesnot execute...

How can execute a Package which is at remote machine without using SQL JOB...

Post #776110

Paul_J

Posted Monday, August 24, 2009 5:28 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 17, 2010 5:56 PM
Points: 185, Visits: 637

It doesn't really matter which sql server the package that you are loading is on. Whichever machine you load the package and execute on is where it gets executed.

If you want to actually execute a package ON a different machine then you will need to either use the sql server agent (you already mentioned this one), write your own service and call it remotely, or remotely execute the command line utility for running ssis packages. Note also that the machine that executes the SSIS packages will need a sql server standard (or above) license.

Post #776375

« Prev Topic | Next Topic »

Permissions