Transform Data Task

#1

I use DTS for transfer data from AS/400 to SQL Server.
Source connection is As/400 and use 'ODBC'.
Destination connection is SQL Server and use 'Microsoft OLEDB Provider for
SQL Server'.
In [Source] tab of Transform Data Task , i use 'SQL query' like this.

SELECT * FROM "AS400"."LIBRARY1"."TABLE1"

My problem is i want to change LIBRARY1 by read value from Grobal Variable.

How can i do this?
Thanks in advance.

#2

How about this

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

--

----------------------------
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

"ton" <barameek (AT) inglife (DOT) co.th> wrote

Quote:

I use DTS for transfer data from AS/400 to SQL Server.
Source connection is As/400 and use 'ODBC'.
Destination connection is SQL Server and use 'Microsoft OLEDB Provider for
SQL Server'.
In [Source] tab of Transform Data Task , i use 'SQL query' like this.

SELECT * FROM "AS400"."LIBRARY1"."TABLE1"

My problem is i want to change LIBRARY1 by read value from Grobal
Variable.

How can i do this?
Thanks in advance.

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

Transform Data Task

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

Transform Data Task - 09-14-2003 , 07:21 PM

Re: Transform Data Task - 09-15-2003 , 01:36 AM