As an asp / sql dev myself I only see a few ways:

+Use a Stored proc and manipulate the string in SQL before inserting.

+Create a User Defined SQL function to...

Try creating a DTS package with 2 Copy Sql Server Objects Tasks

#1 to copy from A to B

#2 to copy from B to C

You can specify in the tasks to...

Thank you!

Makes sense.

We do not have a Domain Server so I guess i am forced to use Local System Account flex_sql.

Good point about 002. It is a 3rd party...

Yes that does help.

Do you know of any good reading sources on practical applications using Lookups?

My old Manager

Brian LaClair from New Tech!

I have ran into something like this before.

I used an Active X script in the DTS.

In the script I checked for certain values and if needed I would skip the...

Don't quite understand them myself but a friend mentioned a Lookup query could be helpful in this case.

Not sure how though.

Thanks for the reply,

Not quite getting yet how it is used in the DTS.

From what I understand, and correct me if wrong, Lookups are available while DTSing from a Source...

Just a thought but could they not be logging in as what you expect.

Turn on sql profiler and what when they hit the table. It will tell you how they...

Set up a DTS package with 2 steps

Step1 DTS Files to master table

Step2 DTS contents of table to new target file.

Set up a job to run the package.