Home Forums SQL Server 2005 Business Intelligence avoid special symobles in ssis RE: avoid special symobles in ssis
Umer Akram
SSC-Insane
Points: 22209
More actions
May 9, 2014 at 12:58 am
#1712055
use 'Data Conversion' in you Data Flow, try to convert the ID column in Int,
click Configure Error Output, on Error Column Change the Fail Component to Redirect Rows.
Create a another table for that and drag the RED flow to that table.