Export File using the DTS package
Hi,
I have a DTS package scheduled to run every day creates a text file on Server A and then moves the text file from Server A to Server B. But recently, the package is moving incomplete text file from Server A to Server B. Not every day. There is no problem in generating the text file.
So far, I verified the memory on Server B - No Probelms.
Changed the package so it copies the text file from Server A to Sever B instead of moving, then delete the text file on Server B. - Didn't work out.
Any idea?