DTSLookups in source - SQL Server Forums

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)

DTSLookups in source

Author

Topic

Crafty
Starting Member

3 Posts

Posted - 2008-03-25 : 02:18:33

Is there a way to use DTSLookups in the source query?
Im Copying Invoices from from one database to another on a nightly basis, but only want to select invoices that has not yet been copied to the dest. db. So my source query in dts should look something like this:


SELECT *
     , 9 AS CRUSerID
     , GETDATE() AS CrDate
     , 0 as void
     , 1 as CompanyID
FROM      
   INVOICEH
WHERE
   InvoiceNum not in (DTSLookups(invoice numbers from DB))

Only some can learn from other peoples mistakes. The rest of us has to be the other people...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources