
May 13th, 2003, 01:41 PM
|
|
Junior Member
|
|
Join Date: May 2003
Location: Quebec, Canada
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Re: DTS Global Variable - Type Mismatch
Quote: Originally posted by i.henderson
I'm trying to get my head around DTS for the first time using the example at URL .
I've created the package as per the instructions, but when I try to save the package I get an error "Error source: Microsoft Data Transformation Services (DTS) Package"
Error description: "Type Mismatch"
It seems to be caused by setting the Global variable "gResults" to type <other> (saves it as 'Variant'.) Can anyone give me any idea how to get around this?
I'd really appreciate any help. |
You have to execute the Parameter Step first. I had the same problem with an integer parameter. I could not specify the type at all. Then I let the default of "Variant" it showed, but after I executed the step it switched to "int" and I had the values of the parameters set up too. Note that, if you want to use your parameters in another step of the DTS you have to specify (at least for SQL) wich Global Parameter will match wich SQL parameter (?). With activeX you have to use the DTSGlobalVariables( ).Value method.
Regards,
Bernard Tremblay

|