Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Executing dtsx Package from Remote Machine Expand / Collapse
Author
Message
Posted Monday, August 24, 2009 9:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Monday, August 24, 2009 5:28 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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 »

Add to briefcase

Permissions Expand / Collapse