How to read more than 500 columns from xlsx file and load them into SQL table (dynamically created at time of loading ) through ssis script task?
I have xlsx file with multiple tab and each tab has more than 500 columns. I have to store these data into SQL table and table will be created for each tab with tab name.
i tried to this using C# code and directly openrowset but it always returning 256 columns.
Divrer: ACE:14 2010
Please help me to work out this problem..
CSV is much easier then Excel! If that's an option... go for it.
It's a bit devious, but if 255 is the limit then perhaps you could read it in two steps? First Column A to IU and then IV to SP...
SELECT * FROM [Sheet1$A:IU]