im trying to insert a new row inside an execute sql task and store the scope_identity() into a variable, this is proving harder than I would have thought.
I have amanged to store it to a result set by doing
Insert into &.. ;
But then I have to use a loop to get the individual column from the result set, I dont like doing this because I only have one row so seems silly to loop through one row..
If you have any ideas, it would be appreciated.