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 Development (2000)
 Ignore some DTS records

Author  Topic 

frist44
Starting Member

12 Posts

Posted - 2010-06-28 : 10:20:14
I have a DTS package that takes some data from one server and puts it on another. In putting it on there other, it has to do a lookup for account number (translated from customer number). On the lookup, some records don't produce an account number because they're not in that system. However, the accountno field is not nullable, so having the data set already, how would I dump the records that don't translate to an account number?
   

- Advertisement -