CODEWITHSUNDEEP
excelssis
reddy r kiran
reddy r kiran

Reputation: 41

Excel Source in SSIS Column limitations

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

Upvotes: 4

Views: 5727

Answers (4)

user3140982
user3140982

Reputation: 135

you could use two data sources to load the data then join them together as explained in this Post

Upvotes: 0

user2362653
user2362653

Reputation: 11

Yes, I had to save the Excel file as CSV, and then I had access to all 360 columns in my import file. NOTE: Because I wanted to save errors out in the same format, I needed to have my ERRORS file in CSV as well, and the error file had to exist when I set up the connection to it, with only the column headings in the first row, so that all the columns would map automatically in SSIS.

Upvotes: 1

reddy r kiran
reddy r kiran

Reputation: 41

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..

Upvotes: 0

ajdams
ajdams

Reputation: 2314

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.

Upvotes: 0

Related Questions