Running SSIS Packages in Batch file remotely

• kasaranenikiran-725528

  SSC Eights!

  Points: 818

  More actions

  January 12, 2010 at 5:19 am

  #136542

  In our existing environment, We have SQL 2005 and Varicent Tool on same box. We have specific SSIS Packages which were put in a batch files and scheduled from Varicent Tool.

  But, In the new environment, we have put SQL 2005 on a different machine and Varicent on different machine. But, we still need to run those batch files to be scheduled and run from Varicent ( which does not have SQL Server on it )

  Is there a way we can do this ?? Suggestions Please .

  Regards

  KK

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  January 13, 2010 at 9:16 am

  #1103138

  Check SQLBI DTExec. It can help with the remote package execution.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/