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 2014
User contributions licensed under CC BY-SA 3.0