Dump everything first in staging table which all columns as varchar. Post that each column must be validated via Data conversion and set the error output as desired.
Data validation in SSIS Print
Modified on: Mon, 18 Apr, 2016 at 5:20 PM
Did you find it helpful?Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.