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
unsure on the oracle part as dont use it but I would think you need two execute sql tasks one which points to the oracle connection manager, the other to the sql connection manager which both execute the stored procedure on each server
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply