SQL Server Performance Forum – Threads Archive

dts disk error handling

While exporting a data from sqlserver to access iam facing error as diskspace lesser then filesize.How to do errorhandling for this case.I have written a script where iam comparing filesize and diskspace but it is of no use as i have written this after this transformation got failed .so i couldnot get originalfilesize.
How to do error handling in such a type of cases.
I guess one way is to log a error in logfile.But i want to trap the error and give meaningful message to user.
Thanks
Thangam

---

If you execute your transfer through an ActiveX script task you might be able to trap the errors that way. Some links:
www.winnetmag.com/SQLServer/Article/ArticleID/6196/6196.html
www.sqldts.com

---

]]>