April 14, 2010 at 5:13 pm
Hi, I have a package that imports data from a .txt file into a SQL Server database.
I use a job is SQL Server to run the package.
How do I handle the error below when the txt source file is not found?
Warning: 0x80070002 at Data Flow Task, Flat File Source [1]: The system cannot find the file specified.
Currently it just fails but I would like to some how get a message telling me that the txt file was not found.
I will appreciate some help.
Thanks,
Jose
April 14, 2010 at 10:09 pm
Add a script task to the control flow and look to see if the file is there. If not then send an email. Those are the broad strokes..
CEWII
April 15, 2010 at 6:43 am
I have configured the Event handler for OnError for this where I have added the SMTP mail task to send mails.
Rex Smith
April 15, 2010 at 7:50 am
Super.
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply