FTP DTS Task Deleting File Upon Completion

kevintblack
kevintblack used Ask the Experts™
on
I have created a SQLServer DTS script to retrieve and process a file located on an IIS FTP server.  

The FTP step of the process seems to be working as expected, but it deletes the file once it has been fully downloaded.  It does not generate an error, and if you watch the destination directory you see the file created, populated, and then deleted.  I have another FTP that is working as expected.

This is obviously throwing a big 'ole monkey wrench into the rest of the processing.  Has anyone seen this before?  I am fairly new to the FTP Task, so I really hope it is a matter of me doing something stupid and not an inherent problem!

Kevin
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2004

Commented:
Usually, the FTP process with delete the file if it WASN'T successful.  Are you totally positive it's not timing out or something and aborting?  Can you look at the IIS log to see if the transfer was successful?  If you execute the SAME ftp command from a "dos" prompt, what happens?

Author

Commented:
The FTP process is returning 'success', and follows the path I expect it to follow after a successful download.  It should terminate the DTS package when it fails.  That is not happening.

I did check the IIS log before, and it reports a successful download every time it is run.

The DOS FTP works as expected.
Top Expert 2004

Commented:
Weird.  You don't have any other automated processes that cleans up that folder do you?  Any other steps in the DTS package that deletes the file when it's done?
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Author

Commented:
No.

If I run the Step as a stand-alone process, it does the same thing.  It downloads the file, deletes it, and returns a successful completion.  There aren't a lot of settings I can tweak either.  I'm stuck.

Top Expert 2004

Commented:
Ya, I'm at a loss too.  I assume you have the right permissions or it wouldn't even create the file in the first place--you are FTPing from DTS with the same account/password that you used to test from the command line right?

Author

Commented:
Sorry, I've been out of town.  Yes, same password.

I'm running into the same problem have you found an answer yet?

Author

Commented:
No.  I have never been able to fix the problem.  I reworked my process to shell out and perform an FTP.  It isn't as slick, but at least it works.  I left this question open hoping someone else might eventually have an answer.  As you can see, I haven't gotten much feedback.  I spent a lot of time trying to track it down in other forums too - no luck though.
Top Expert 2004

Commented:
Ya, this really should be closed since it's over 21days old--requeste a DELETE/REFUND in the CS area with a link to this question.
I figured it out...Update to Service pack 3a..It fixed the problem.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial