Exec stored procedure
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
March 28th, 2012 10:14am
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
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2012 2:32am
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.
April 1st, 2012 2:43am
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
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2012 3:19am