I newbie to SQL Server Integration Services and I have a problem:
Data loaded from file looks like this:
1 'a' 'b' 2 'a' 'b' 1 'c' 'd'
And this rows would be loaded in table like this:
CREATE TABLE T ( ID NOT NULL PRIMARY KEY, A nvarchar NOT NULL, B nvarchar NOT NULL );
ID is primary key third row in input data could not be loaded, and I want to load correct rows (first and second or third and second) and send to log incorrect row.