Re: Global Variable Array to DDQ Parameter

#1

Worked like a champ...Thanks

Quote:

-----Original Message-----
Try a different approach

Build the statement in an Active Script task and assign
to the DDQ.

set the SourceSQLStatement of the DDQ to

"SELECT <col list> FROM table WHERE <col> IN " &
DTSGlobalVariables("ArrayOfVals").Value

What you are proposing initiallly would not work in TSQL
either

declare @a varchar(50)
set @a = '(''123'',''1124'')'
select * from authors where au_id in @a

--This would work though
declare @a varchar(100), @WholeString varchar(200)
set NOCOUNT On
set @a = '(''123'',''1124'')'
set @WholeString = 'SELECT * FROM Authors WHERE au_id
IN ' + @a
Exec(@WholeString)

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
.

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

Re: Global Variable Array to DDQ Parameter

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

Re: Global Variable Array to DDQ Parameter - 08-11-2003 , 09:46 AM