No File notification

[balistikb]

In my DTS I want to schedule an import of a text file to a table in SQL. I already have this and it works great. What I would like is to get an email letting me know when there isn't a file to import. I tried attaching a send email task to the transformation but that didn't work. Any ideas?

 

[JohnDTampaBay]

Here's an article that discussing checking for file existence. Basically, you will need an ActiveX script to check for file existence, and fail if it doesn't exist or succeed if it does. Then use an On Success workflow to tie the ActiveX script to the import step and an On Failure workflow to tie to an Email task. Good luck!

http://www.sqldts.com/?211

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)