March 9, 2008 at 2:08 pm
I want to execute a stored procedure in an 'Execute SQL Task', who's giving
the following result:
Connectionstring Client
-----------------------------------
Connectionstring A Client A
Connectionstring B Client B
Next I want in a Foreach Loop Container to loop through these records. I need the column 'Connectionstring' to establish a connection in the source of a dataflow. The column 'Client' is used in a derived column to adjust a new column.
How must I configure the 'Execute SQL Task' and the 'Foreach Loop Container'?
I've tried this with only the column 'Connectionstring' and that was working fine. But when I want to store the result of the client column, I get an error. Is it possible to retrieve multiple records with multiple columns and store these results in a variable?
March 10, 2008 at 3:31 pm
You would need to setup 2 variables. 1 for the connection string and 1 for the client.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 11, 2008 at 3:10 am
I found the solution. Look at http://sqljunkies.com/WebLog/knight_reign/archive/2005/03/25/9588.aspx for an example.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply