Re: Type mismatch error while saving Pkg with ARRAY global variable

#1

I seem to remember I did this as well and was told you cannot do it like
this.

Why do you need the GV?

Why not use an array inside the VBScript task?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"dwaine" <dwaine (AT) nospam (DOT) nospam> wrote

Quote:

I've seen lots of posts (and solutions) with people trying to save
recordsets
to a global variable. However, I seem to be the only one trying something
that would be as common and more simple in my opinion, creating an
explicit
global variable of type array.

Basically, I'm parsing a file to get the names of DTS pkgs to run and
placing the list into an array of strings to be processed by subsequent
tasks. I want the variable defined EXPLICITLY so I can easily access it
in
the scripting window. I can run the step that populates the variable and
save the package as long as I don't try to explicitly define the global in
the package properties. If I try to define it on the global variables tab
(as
a string OR <other>), then running the step works, but the package won't
save. Looking in the global variables tab shows the type has been changed
to
BLANK.

A simple test case follows, if TestArray is explicityl defined as ANY type
and the step is run, the package can't be saved! This is a show stopper
for
long term maintenance of packages.

Function Main()
'Create test array and place in explicit global
dim strTest(2)
strTest(0) = "One"
strTest(1) = "Two"
msgbox strTest(0) & " and " & strTest(1)

DTSGlobalVariables("TestArray").Value = strTest

Main = DTSTaskExecResult_Success
End Function

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Type mismatch error while saving Pkg with ARRAY global variable

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Type mismatch error while saving Pkg with ARRAY global variable - 09-02-2004 , 02:16 PM