Redirect Error to log error into a table is not executing

0

I am trying to load 200000 rows into a table. However, after inserting 1,29,024 rows. the SSIS package is failing with the following error:

Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Conversion failed when converting the nvarchar value 'X' to data type int.".

There are 40 columns. The package fails every time at 1,29,024. I tried to log record with the problematic data into a separate table, however, the log component is not executing.

What I am doing wrong here? How could be the possible reasons why the error log component is not executing even though the OLE DB Source is failing?

Softwares: Visual Studio 2013 Professional SQL server Data Tools 12.0.3 SQL Server 2014enter image description here

sql-server
logging
ssis
asked on Stack Overflow Oct 27, 2018 by Ora Aff • edited Oct 27, 2018 by a_horse_with_no_name

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0