am moving data from a view in one server to another server via the "Microsoft OLE DB Provider for SQL Server"

Here is the plan

S1 ----Transform Data Task-----------> S2...

Thanks for your help the where insert date = null was a mistake.. in the code..

If you are look at different SOX applications and are thiking of buying one i use to work for a compnay that developed SOX software so i can put you...

Are you sure the file was not corrupted during transfer?  Did you use FTP without specifying Binary mode?

Sorry can you explain what you mean by setting the file to Binary...

Hey yes sorry i will in the future but yes i was thinking in the same lines as you the command am working on is

copy c:\temp\te*.txt = c:\temp\temp.txt

Which copies all...