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
 Import/Export (DTS) and Replication (2000)
 Importing data and lookup query ?

Author  Topic 

NoCode
Starting Member

1 Post

Posted - 2007-01-10 : 05:30:50
Hi,
I know that it is possible to import data from a SQL server database into a SQL server database while doing a lookup query but, is it possible to import data from i.e. DB2 database (different database) and do a lookup query on the SQL database all in the same transform data step ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-10 : 05:38:52
I don't think DTS think differently about DB2 data, as long as it is still OLE DB compatible.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -