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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Global Output Parameters - Type Mismatch

Author  Topic 

midimark
Starting Member

2 Posts

Posted - 2004-07-19 : 09:19:26
I found some demo code that allows me to return the result set of a query to a Global Output Parameter in a DTS package.

http://www.dotnetbips.com/displayarticle.aspx?id=228
http://www.devguru.com/features/tutorials/DTS/DTS3.html

On both of them I get a Type Mismatch when I attempt to save the package.. they both say to use a data type of <other> for the Output parameter, which changes it to variant once I exit the create Global Variable screen. If I remove this output param the package saves, once I add it back in it fails to save and returns the Type Mismatch error message, so I have it narrowed down to this Global Var... but am having trouble figuring out why I am getting this type mismatch error...

Any ideas on a solution?
   

- Advertisement -