How to import excel file having more than 255 columns in it using SSIS ( there is limit of 255 columns for excel connector ) Can we use script task?

Asked Jan 27 '22 at 20:03

Active Jan 27 '22 at 20:17

Viewed 23 times

I am trying to import excel files that have multiple tabs and more than 255 columns? Can we import such files using SSIS? In ssis excel connector has a limitation of 255 columns? My team has developed other reports and ETL packages so we want to find a solution for this bottleneck.

Please share your experience

Thanks

edited Jan 27 '22 at 20:17

Hadi

34,224
11
61
121

asked Jan 27 '22 at 20:03

Maverick_9090

How to import excel file having more than 255 columns in it using SSIS ( there is limit of 255 columns for excel connector ) Can we use script task?

0 Answers0