dts disk error handling | SQL Server Performance Forums

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.
If you execute your transfer through an ActiveX script task you might be able to trap the errors that way. Some links: