March 2, 2010 at 4:06 pm
Hello everyone,
Can someone explain how to use SQL query results as parameters to execute a stored procedure in a Foreach Loop Container.
The idea is to use the identifier of the client to ask an Oracle Stored Procedure all customer information. Then store that information in a SQL table.
Thank you for your advice 😀
March 2, 2010 at 4:34 pm
Here's an article that helps with that
http://decipherinfosys.wordpress.com/2008/03/15/ssis-execute-sql-task/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 2, 2010 at 10:18 pm
Once you do that - configure the foreach loop to pull data from an ADO enumeration, then point to the variable you pre-loaded. index 0 = column 1 of the recordset, index 1 = column2 of recordset, etc....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply