Hi i create a stored procedure in oracle and sql server ..now i want to execute this stored procedure by using ssis package how to execute stored procedure i want to create same exec condition for both oracle and sql server i don't want to change that For each environment how to do that To execute the 2 SPs you would need to 2 providers, and you cannot configure the same Execute SQL Task for 2 providers. You would have to use 2 execute sQL Tasks, one for oracle and one for SQL Server. in you for each loop you could use precedence constraint to decide which task you wish to execute.My Blog | Ask Me | SSIS Basics

Hi i create a stored procedure in oracle and sql server ..now i want to execute this stored procedure by using ssis package how to execute stored procedure i want to create same exec condition for both oracle and sql server i don't want to change that For each environment how to do that

Pleaese follow http://beyondrelational.com/modules/2/blogs/43/posts/10201/getting-started-with-ssis-executing-a-sql-server-query-or-stored-procedure-from-ssis.aspxThanks Manish Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Hi i create a stored procedure in oracle and sql server ..now i want to execute this stored procedure by using ssis package how to execute stored procedure i want to create same exec condition for both oracle and sql server i don't want to change that For each environment how to do that To execute the 2 SPs you would need to 2 providers, and you cannot configure the same Execute SQL Task for 2 providers. You would have to use 2 execute sQL Tasks, one for oracle and one for SQL Server. in you for each loop you could use precedence constraint to decide which task you wish to execute.My Blog | Ask Me | SSIS Basics