I am new to DTS packages.
I have to extract data from SQL Server Database and store it in CSV
files.
In addition to that I need to extract a few columns as Lookup Data from
the Oracle Database also to the same CSV file.

Is this possible to have Lookup from a different Source Database?

Awaiting reply

RJ

Hello oichi,


You can certainly do what you want yes. You can use a linked server from
SQL Server to Oracle and perform the Lookup/Join in a query and dump to CSV.

There are other ways also


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thanx for the reply Allan.

I was able to perform Lookup and get values from Oracle Db.

But there's a small problem

When my Lookup Query Looks like this, it runs successfully.

Select SZNETWORK ( SZNETWORK is CHAR )

But I want to add a 'Like'

So when my Query looks like this

Select SZNETWORK

It fails.

Would appreciate ur help.

Thanx
oichi

Hello oichi,


OK. That is probably because the design time is not too stable with params
and complex statements.

Try redoing it like this

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


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thanx Allan.

That was a great help

I appreciate ur help.

Oichi