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 the first statement in your SQL query in sql task.