asked
Calling one stored procedure from another using ssis
Hi , I have 2 stored procedures A and B . A returns multiple rows , I want to select each row to call stored procedure B. I am kind of routing for OLE DB Command for this , but not sure how to start and go about with the flow . 1. I use Execute SQL task for call the 1st stored procedure 2. Use OLE DB Command to call Stored Procedure B. 3. I use this by mapping a parameter from A and B? Any help/suggestion would be grt...
You can either do this via strict T-SQL which would be letting SQL Server do all the work technically. Other option is to send your output for procedure A to an object parameter in the SSIS package. You then build a foreach loop on that parameter that iterates over each row, and within that container just call the execute t-sql task to call procedure B.
18 People are following this question.
