Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 10th, 2003, 11:27 AM
i.henderson i.henderson is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Brighton, England
Posts: 2 i.henderson User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy DTS Global Variable - Type Mismatch

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.

Reply With Quote
  #2  
Old May 2nd, 2003, 07:03 AM
i.henderson i.henderson is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Brighton, England
Posts: 2 i.henderson User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Solved the DTS Type Mismatch problem

Found a solution on the web - simply execute the package before you try and save it.

Reply With Quote
  #3  
Old May 13th, 2003, 01:41 PM
imaginasys imaginasys is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2003
Location: Quebec, Canada
Posts: 1 imaginasys User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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

Reply With Quote
  #4  
Old June 10th, 2003, 03:31 PM
bryanard bryanard is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2003
Posts: 1 bryanard User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy http://www.devarticles.com/art/1/64

Anyone know why output from a stored proc won't work with this?
It loops forever and writes lots of blank lines....

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > DTS Global Variable - Type Mismatch


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT