Error Source : Microsoft Data Transformation Services (DTS) Package.
Error Description : Type Mismatch
This error will occur when trying to save a local server package with contains a
global variable of type <other> or Variant.
The most common cause of this is when using the Execute SQL Task and following the Microsoft SQL Server 2000 Books
Online How to save an entire rowset into a global variable, where it describes creating a global variable of type <other>. If you try and
save the package to SQL Server it will error as above. The type will have been changed to Variant, but it will still
produce the same error if you try to save it again.
If you execute the package the variable will be changed to the correct type Dispatch which will allow you to save the
package. Alternatively you can just leave the type as the default String and it will save and execute correctly.