Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Execute SSIS on a remote machine

Answered Execute SSIS on a remote machine

  • Friday, January 18, 2013 3:33 AM
     
     
    Sign In to Vote
    0

    Hi

    I want to a application on Appserver that should execute SSIS package on db server. I placed the SSIS pkg on db server as the integration services are avaiable on that server. i am calling a bat file (placed in appserver) from application and that bat file calls SSIS using dtexec. The package is not working as expected . i suspect it is looking for integration services on the appserver.

    I browse through couple of options like having SQL agent job and run the SSIS but i cant run the pkg independent of application as the outcome of package is related to some validation in the application.

    System environment used --> Appserver - windows 2003, db server - windows 2008 OS and SQL 2012

    Appreciate if anyone has a better solution to run a package remotely.

    Thank You

     

All Replies;