The DTS package I created first FTP's in a file from the web server, imports the data from the Excel file to a temp table and manipulates the data before it is dumped into the main table. At the end of the process it deletes the file it FTP'd in and then the remote file on the web server.
Everything works fine.
My question however is if I purposely change the name of a column in the excel file to simulate someone messing up, the process fails but I want to delete the FTP'd file and the remote file but cannot figure out how to do this because you cannot add a ON FAILURE step to the setep that copies the date from the Excel file to the table.
thanks!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
>>At the end of the process it deletes the file it FTP'd in and then the remote file on the web server.<<
Assuming that this only occurs if the previous step is successful, then all you have to do is change it to on Completion, rather then on Success.
If this is not it, post an image of your DTS package and indicate the FTP task if it is not clear.
Business Accounts
Answer for Membership
by: BodestonePosted on 2009-08-07 at 12:33:21ID: 25046171
It looks like you have a job wich has many steps and the DTS is one step in the job.
One way would be to keep a permanant log table which is updated as part of the job.
it could hold logID, startTime, endTime, expectedFileName (if they are name[datetime].xls, status, lastStep
Initial step would create a new record indicating the the file name it was looking for. further steps could ad information and a step number. Each step could have a fail condition to go to the last step which is to delete the excel file, maybe based on the expectedFileName in the latest entry of the log file.
Therefore you get your own custom log of what went wrong and when.
It would generally involve adding in a lot more error catching of your own but once sorted can be pretty stable and allow you to define your own fail conditions for other parts of the job with RAISERROR