August 24, 2009 at 9:40 am
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...
August 24, 2009 at 5:28 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply