I have an excel file with sheet containing 210000 records..I am trying to extract this file into a SQL table.
In SSIS, I am using a Excel source and a SQL server destination adapters. When I am running the package, SSIS is only extracting 4500 records into the SQL table.
If I use a SQL query "SELECT * FROM [SHEET1$] WHERE ID>4590" instead of a sheet name, then no records show in the Preview mode.. Don't know whats going wrong here..
Can someone please explain me what am I doing wrong..Thanks in advance