Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Executing dtsx Package from Remote Machine


Executing dtsx Package from Remote Machine

Author
Message
amit-1143912
amit-1143912
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 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...
Paul_J
Paul_J
SSC Veteran
SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)

Group: General Forum Members
Points: 245 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search