Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  DTS Parameterized Query

Author  Topic  xega Starting Member 10 Posts Posted - 2001-01-15 : 01:43:36 Dear Brains of the Universe, Here is my situation guys. I have 2 differen data source. 1) MARSPROD - Oracle 8.1.7 DB (Remote DB) 2) NGAT - SQL Server 2000 Enterprise Edition. (Local DB) There is a table in NGAT db (FCode). This table contains the local location information. In the marsprod database there is a table which containd data from all location (let say the the marsprod server contains international data and NGAT should contain local data) What I want to do is import data from MARSPROD in to NGAT using DTS. The catch is I only want to import data which has the location specified in the Fcode table. I know in DTS you can use parameters like select * from something where fcode = ? Where ? could be user global variables or user maintained value. What I understand is that the parameter only accepts single value. In my case above I need a resultset from my fcode table to match against the source data. PLease help. Any help is greatly apreciated. Regards Jega Whenever I start to think, my brain freezes therefore I think I'm cool...