Geeks With Blogs
Baskar B.V SQL - BI Consultant September 2007 Entries
Tip on DTS Execute Sql Task
Figured out a solution today while doing my DTS code. I was fighting various ways to get this out but a simple code will do that. When you have an scenerio in DTS where you need to pass in SQL variables like @@rowcount, @@error to your global variables you typically do select @@rowcount, @@error in your execute sql task and map that to your global variables. This will not return you the values as intended. To get the values returned to your global variables you might have to set SET NOCOUNT ON as ......

Posted On Thursday, September 13, 2007 1:18 PM

Copyright © Baskar B.V | Powered by: