Re: Passing SQL Server Variables to Oracle in a 'Where' clause

#1

OK so you return a rowset from SQL Server and want to plug this in to a
WHERE val IN (<your variable>)

I would do this

Read the Values into a Global Variable Rowset
In An AX Script loop over it and concatenate the values into a string
Use the following article to build the SourceSQLStatement of the DataPump
task

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

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

Quote:

Could someone please assist me or direct me to a source that explains how
to pass values from a SQL Statement from SQL Server to Oracle in a 'Where'

clause without using Linked Server in SQL Server 2000 DTS?

Quote:

The datatype of the returned vlaues from SQL Server is an INT, which is
the same datatype in Oracle.

Since I am returning more than one value from SQL Server, the 'Where'
clause to Oracle would be using an 'IN' statement.

Any help would be greatly appreciated.

Thanks so much in advance.

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

Re: Passing SQL Server Variables to Oracle in a 'Where' clause

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

Re: Passing SQL Server Variables to Oracle in a 'Where' clause - 02-20-2004 , 12:47 AM