February 6, 2007 at 9:02 am
I need to pull dynamically filtered data sets into SQL2k from Oracle on a regular basis using a DTS package. But I haven't had any luck using a global parameter in the OPENQUERY() string that I want to send to the remote Oracle db. When I use the four part linked server of course it pulls back millions of rows that I don't need. OPENQUERY is the way to go...anyone had luck using it in DTS?
Or is there a better way?
Thanks
A.S.
MCSE, ASE, DBA
Webmaster
Applications Developer
February 8, 2007 at 9:17 am
Did you set up an ODBC connection for Oracle ? If not how do you get Oracle data ?
February 8, 2007 at 10:55 am
Yes...all the connections are setup & ready to go in a DTS package. I'm now at the point of pumping filtered data from the remote Oracle db to my local SQL2k db.
A.S.
MCSE, ASE, DBA
Webmaster
Applications Developer
February 8, 2007 at 12:00 pm
Yes, I use DTS all the time to retrieve data from Oracle to SQL Server all the time. I have an Oracle connection and a SQL Server Connection and use Transfer data task to transfer the data from Oracle to SQL Server. You can transfer the whole table or you can write a query to retrieve the data that you want to transfer to SQL Server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply