Calling SSIS package in Stored Procedure...

Question

I have a SSIS package, and i want to call this (run this SSIS package) from Stored Procedure in Sql Server 2008.

Can anyone  please explain to me as to how can i call SSIS package from SP?

 

Thanks!

---

Rahman

Answer 1

One way to do this is to create a job (to run SSIS Package) and use sp_start_job  within your stored procedure to run SSIS Package.

Make sure your package location be SQL Server, and keep Protection Level Encrypt sensitive data with user key (connection information is encrypted in the SQL and not in user profiles.) 

 

---

Sharjeel Ashraf

Answer 2

Thanks for the reply.

Appreciate it.

---

Rahman

Answer 3

Ted Kruger explains how this can be done in his blog post

 

Run SSIS Package from Stored Procedure

 

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 4

I have an SSIS package sensitive encrypted with password deployed and present in Catalogs and I want to run it by means of a stored procedure. How can I pass the password?

Many thanks

Carlo