Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to execute ssis package through stored procedure RE: How to execute ssis package through stored procedure
Erik Kutzler
SSCarpal Tunnel
Points: 4287
More actions
December 30, 2008 at 7:03 am
#919019
The easiest way to do this would be to create a SQL job that executes the SSIS package, then execute the stored procedure master.dbo.sp_start_job to run the job.
You could also execute master.dbo.xp_cmdshell to run a dtexec command.