All geek questions in one place

Excel source in SSIS column constraints

Is it possible to import data from Excel with more than 256 fields into an SQL database using SSIS. If there is any trick for this, since I could not see more than 255 columns in the selection of columns in the Excel source in SSIS

+3
source share
4 answers

Yes, I had to save the Excel file as a CSV, and then I had access to all 360 columns in my import file. NOTE. Since I wanted to save the errors in the same format, I also needed the ERRORS file in CSV, and the error file should have existed when I established a connection with it, with only the column headers in the first so that all the columns would automatically appear in SSIS.

+1

, 255 SSIS, , , . , .

0

As I tried all the features without success, I tried to convert the excel file to tab delimited text and tried importing. He worked perfectly.

0
source

you can use two data sources to load data and then combine them as described in this post p>

0
source

Source: https://habr.com/ru/post/1740068/

More articles:


All Articles