September 7, 2006 at 12:26 pm
I am having the hardest the time with Variables in a task
I want to output a value to a variable
These are my steps
1- Create a variable
2-Sql task = select max(id) from tbl_1
3- I set the result set paramater to single row
4- I go into the paramter mappings, choose my variable, direction output
5- I go into result set, create a result name and map to a variable.
When I run it it crashes.
September 7, 2006 at 12:57 pm
forget about this I got it.
September 7, 2006 at 2:26 pm
Solution?
September 7, 2006 at 2:36 pm
1- Create a variable
2-Sql task = select max(id) from tbl_1 as id
3- I set the result set paramater to single row
5- I go into result set, create a result name (id) and map to a variable.
Get rid of step 4.
September 7, 2006 at 2:51 pm
thanx
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply