Stored procudure in ssis - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Stored procudure in ssis

Author

Topic

Anand.A
Posting Yak Master

109 Posts

Posted - 2012-03-28 : 02:29:52

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

anand

rajarajan
Starting Member

48 Posts

Posted - 2012-03-28 : 02:53:04

u can XML confi file with variable assign to the input paramter to sp used
when exctute the package u give values to the variable and this variable is assign to the SP used in the package

hope i ans the question

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-28 : 11:48:40

quote:
Originally posted by Anand.A

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

anand

what do you mean by same exec condition? do you mean same set of parameters?

ideally you would be using execute sql task for excecuting procedure
for connection manager you need to use oracle connection parameters for oracle db and sql server connection for sql
is it that you want to make dynamic?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources