You've seen too much Noeld...

How long have you been a dba?

Finally, here's a version where you can search for all occurances, or 1, or any number you want. The list of wanted items is passed as a string so...

Yup, and we'll always need to move files or other simple stuff like that. So I don't predict and early retirement for dos .

I don't need to test it to know it's gonna run faster. .

OK, TIA.

Possible... keeps us posted.

How about a sample of a current record, with any of its deleted versions?

Is there a DOS.NET too?

Can it be permission problems?

Much neater. Should be faster too .

I used this formula because I didn't want to do :

BasePrice * Case when SomeCol is not null then SomeCol Else 1 end + Case when Col2 is not...

Are you sure this is the problem??

Yes for the Execute SQL Task right part.

The syntaxe is :

Insert into dbo.tableName (col1, col2, coln) Select col1, col2, coln from dbo.StagingTable --where condition that flushes the deleted records......

Sorry but I'm too yound to know about COBOL, I barely know how to spell it. My knowledge came from an interview question for a c++ job. They...