Stored Procedure in ssis

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

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?

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?