January 12, 2011 at 8:48 am
Hello,
Can someone please tell me whether it is possible to manipulate data in a table through SSIS task - "Execute SQL task" ?
I wish to change the data for some fields in the table based on a condition. The reason I asked is that the final resultset I am getting is not the desired result and I would need to further apply a condition to achieve the results as per the business requirements.
Thanks in advance for your help.
Regards,
Paul
January 12, 2011 at 8:55 am
Yes, you can - although it's not necessarily the best way of going about it. For example, if you want to manipulate the results from a data flow, then you may find that it would be more efficient to add an extra transformation to your data flow instead.
If you do decide to go ahead with it, just enter the query to do the update in your Execute SQL task designer. If any element of the query needs to be dynamic, you can use paramters or build the query as an expression using variables.
John
January 12, 2011 at 9:22 am
Paul,
Why don't you explain the process to us, it will help give better more complete guidance. I also agree with John that the EXEC SQL task is probably not the right venue but with a data-flow task would be more likely the right spot. But you can do it at either.
The EXEC SQL task can execute virtually any valid SQL statement so an update/insert/delete/select is completely possible.
CEWII
January 12, 2011 at 3:01 pm
I guess the issue is related to this thread.
But it could be something completely different, too...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply