Using DTS global var in a concatinating string

#1

Using a DTS package, I want to use a global variable to concatinate a string
for a table name I want to query. I then want to use the results as my
source for a data transfer task.

I'm trying to use something like....

declare @temp_id varchar(3)
declare @qry varchar(3000)
set @temp_id = ?
set @qry ='select distinct (specialty) as unknowns,
(spec_id) as specId from dbo.a_specialty'
+@temp_id+' where spec_id is null'
exec (@qry)

The source in a DTS Transform Data Task cannot read the SQL statement to
give me my results. Can anyone help out with what I may be able to do???

#2

Have a look here

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

Allan

"Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote

Quote:

Using a DTS package, I want to use a global variable to concatinate a
string
for a table name I want to query. I then want to use the results as my
source for a data transfer task.

I'm trying to use something like....

declare @temp_id varchar(3)
declare @qry varchar(3000)
set @temp_id = ?
set @qry ='select distinct (specialty) as unknowns,
(spec_id) as specId from dbo.a_specialty'
+@temp_id+' where spec_id is null'
exec (@qry)

The source in a DTS Transform Data Task cannot read the SQL statement to
give me my results. Can anyone help out with what I may be able to
do???

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

Using DTS global var in a concatinating string

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

Using DTS global var in a concatinating string - 10-06-2005 , 04:45 PM

Re: Using DTS global var in a concatinating string - 10-06-2005 , 04:50 PM