Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ciaran
Starting Member
40 Posts |
 Posted - 2005-08-16 : 07:18:16
|
| Hi,i am trying to save the results from execute sql task to a global variable RSRetailers. What do i declare the RSRetailers as. the RSRetailers is a global variable. the data coming out of the execute sql task will be a rowset. At the moment i have it as a string but this cannot be correct |
|
|
ciaran
Starting Member
40 Posts |
Posted - 2005-08-17 : 08:47:34
|
| ok figured it out. Somtimes in dts package when you specify a rowset to be entered into a global variable there will be a type miss match when you save the package. the trick is to allow dts to run to where the rowset is entered into the global variable in order for it to figure out that the global variable should not be stored as a variant. Open up the package properties and view the global variable and you will see that the global variable is now stored as "Dispatch" and not as a variant. |
 |
|
|
|
|
|
saving a rowset in dts package