The link works fine for me, from two different machines and different
newsreaders. Granted most newsreaders don't allow for the line wrap in
the link so you have to do a bit of copy and paste, but I had hoped that
Here the relevant part of the posting-
Message 2 in thread
Subject: Re: DTS rowset global variable
View this article only
Date: 2001-06-17 19:40:59 PST
That is a known problem in the Designer, use String data type, do not
a value in the designer. Since it is a VARIANT under the covers anyhow,
will get transformed during the assignment of the recordset to the
into the right VARIANT type.
> I'm trying to create a rowset global variable in a SQL Server 2000 DTS
> package, following the guidelines in the "Execute SQL Task" topic in
> Online. When I use the pubs database, it works just fine, but when I
> to do the equivalent with a table in a different database, I get a
> mismatch error" when I attempt to save the package. I believe I've
> this to a minimal test case; I have a package that executes the select
> statement I want, against the correct database, and I can save that.
> modify the Execute SQL Task to create a global variable of type
> the instructions, and attempt to save the package, I get the type
> I have a workaround, but it doesn't offer the error checking that this
> method will.
> Any ideas?
> Ken Warren
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com