Export File using the DTS package

[Anne]

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?

[rmiao]

Why don't create file on server b directly? By the way, does data dump complete when you start copying file?

[Anne]

That's a good question. Don't t know the answer for it.

The problem still occurs even I start copying the file. The thing is it is not happening every day. Somedays the package moves/copies the complete file from Server a to b. Somedays incomeplete file (moves file with only 1 to 3 lines of data).

The DTS package is in use for a year, no changes have been made to it.

[rmiao]

You can enable package logging to figure out what happens.