bhoelzer - Tuesday, October 9, 2018 5:03 AM
Hi Bhoelzer, the bulk insert task is designed for performance, hence there is no way to perform validations with this component, you will have to replace the Bulk Insert Task with a Data Flow Task and perform a data cleansing there (or you can put another step before the bulk insert to format the file).
Hope this helps!
MCSE, MCSA SQL Server Database Developer/Administrator