I am connecting from SSIS to an Oracle database to import data into SQL Server. I can preview the data in SSIS:

The issue is when it imports this into SQL Server, the column FOUR shows as all NULLS for all 110 million records. When there is data in there. From reading about this error excel reader reads the first 8 rows and determines the type/data?

This is the table structure:

I have tried to use a data conversion to DT_STR which didn't work. I also tried INT and that column is still showing as NULL.

CodePudding user response：

Since Excel is not a relational database, OLE DB tries to discover the most relevant metadata from the Excel worksheet by investigating the data. This is not the case in Oracle.

Please make sure that your columns are mapped correctly in the OLE DB Destination.