SQL Server Performance Forum – Threads Archive
dts disk error handlingWhile 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: