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
Not sure I understand what you are asking. You have a stored procedure in Oracle and SQL that is the same name?
If I am reading that right then I would use four variables.
1. That contains the Sproc name
2. Contains the execute command in SQL syntax
3. Contains the execute commane in Oracle Syntax
4. Combine either variable 1 and 2 or 1 and 3. This can be different based on an expresion.
Let me know if I am missing your question.
1.oracle SP syntax - execute
2.SQl Sp Syntax - exec Sp Name.
Better you can use a variable to define the oracle and Sql execute statement.
My Question IS the same SP you are going o run in oracle as well SQL?