Can we import data from Excel with more than 256 fields in to a SQL database using SSIS. If so is there any trick for this, as I couldn’t see more than 255 columns in the column selection at Excel source in SSIS
+1
A:
If you mean you couldn't see more than 255 rows in the Data Source Component's preview within SSIS then that is expected since I believe that is the most it will show you. Of course all the rows will be imported.
ajdams
2010-04-08 13:15:20
A:
As i tried all avenues with no success, i tried converting the excel file in to a tab delimited text and tried the import. It worked superb..
reddy r kiran
2010-06-17 18:47:11