I have done Error Handling by getting the Error Column name from the lineageId and forming custom error message.

http://www.nkannan.com/2012/02/error-handling-in-ssis-dft.html

Thanks,

Nk

http://www.nkannan.com/2012/02/error-handling-in-ssis-dft.html

hope this is useful to you.

Thanks,

Nk

Hi ,

Please find the below blog where i have updated similar error handling.

http://www.nkannan.com/2012/02/error-handling-in-ssis-dft.html

Thanks,

Kannan

I have updated Error Handling in SSIS in the following blog . Please let me know if you find it useful.

http://www.nkannan.com/2012/02/error-handling-in-ssis-dft.html

Thanks,

Nk

I have validated the data in the package.

If you had noticed I have validated the area code for the expression

@"\(?\s*\d{3}\s*[\)\.\-]?\s*\d{3}\s*[\-\.]?\s*\d{4}"

similarly we can validate any column and the redirect...

http://arookiebidev.blogspot.com/2011/06/validation-in-ssis-package.html

I wrote a blog on data validation in SSIS package using script component.Hope this will be of some use to you.

Cheers,

NK

Hi ,

The VIEW ANY DATABASE permission should be granted to the role. By default it will be enabled.

Thanks,

Kannan

thanks for your reply..

the link was useful...