SSIS – Let the Excel connection manager pick the right column data types from an Excel source
The excel connection manager scans every first 8 rows to determine the data type for a column in your SSIS
Azure Solutions Architect writing about Azure Data & Analytics and Power BI
The excel connection manager scans every first 8 rows to determine the data type for a column in your SSIS