Monday, March 12, 2012

Execute SSIS package from ".vbs" file

I need to execute a SSIS package from a ".vbs" file on a computer that don't have SSIS installed on it.

Thank You

The only way to remotely execute a SSIS package is to set up a SQL Server Agent job to run the package and run that remotely. If you can find a way of doing that in a .vbs file then you're laughing.

-Jamie

|||You can use ADO (from VBS) to call sp_start_job for an existing SQL Server Agent job, or even create a new job and then start. SSIS is not client/server as per SQL Server, it executes the package on the host machine. You need to use another technology to communicate wth the "server", hence the suggestion of using SQL Agent to host the process.

No comments:

Post a Comment