FTP DTS Task Deleting File Upon Completion

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
kevintblackAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arbertCommented:
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?
0
kevintblackAuthor 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.
0
arbertCommented:
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?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

kevintblackAuthor 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.

0
arbertCommented:
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?
0
kevintblackAuthor Commented:
Sorry, I've been out of town.  Yes, same password.

0
chris0000leeCommented:
I'm running into the same problem have you found an answer yet?
0
kevintblackAuthor 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.
0
arbertCommented:
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.
0
chris0000leeCommented:
I figured it out...Update to Service pack 3a..It fixed the problem.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.