DTS Query Depending on External File Contents

[123FakeSt]

In SQL server 2000 I am pulling data from a Sybase database through DTS. I also have a text file with ~300 account numbers. These are the two connections on the DTS package.

I would like to only pull the data for those accounts. In other words "only pull the account data for the accounts listed on this text file". What would be the most effecient manner to achieve this? A lookup?

The early bird gets the worm, but the second mouse gets the cheese.

 

[jt8941]

Has this been resolved, I have the same question?

 

[123FakeSt]

Well I ended up with an ActiveX task that read the file through the file system object. Then it replaced the VbCrLf's with commas.

The transform data task custom SQL settings were created by the script inserting the value in the WHERE clause.

The more elegant solution would be to import the data as a Table variable

DECLARE @tblAccount as TABLE (acctID INT)

then include an inner join to it I imagine.

Hope this helps!

The early bird gets the worm, but the second mouse gets the cheese.