Thanks for the pointer

Thanks for the pointer. The code is the same. The data for the joins in the two environments are slightly different, because the test server data is a restore of...

Thanks for the prompt response. It will hard for me to send you my script and data because of privacy concerns of my company. I just need some high level...

Thanks for the info. Do you mean to say that SSIS can do this job for me. And if it would you point me to some good links to get...

This is a snapshot of the incoming file

e-TIME,,,,,,,,,,,,,,,,,,,,,,,,

Co Code,Batch Id,File #,Pay #,Rate Code,Temp Dept,Temp Rate,Reg Hours,O/T Hours,Hours 3 Code,Hours 3 Amount,Hours 3 Code,Hours 3 Amount,Hours 3 Code,Hours 3 Amount,Hours 3...

Phi,

That is exactly the case here, the number of coulmns can change from line to line and at this point I do not have control of the incoming file. Any...