Geek asks and answers

Excel source is not synchronized when loading data from a spreadsheet into a database using SSIS

I want to load information from an Excel table into a database using the SSIS package, and the package works fine when the table does not change.

One of the requirements for this task is to allow users to add comments to the spreadsheet. There is already a column for comments in the spreadsheet, so users simply add comments to this column.

When they save the edited spreadsheet and I run the package, the Excel source complains that the external columns are out of sync and even weirder, the number of columns displayed in Mappingis smaller than the original table.

What causes this and how to fix it so that I can automatically run this package as a scheduled task in SSIS?

+3
source share
3 answers

Found a problem: my table had several small empty columns in front. I assume that when the user saves the information back, these columns are deleted using excel (?), Therefore the columns are shifted, which leads to desynchronization with the package.

+1
source

try removing auto-match column names.

Excel , . , false. , , , , , - excel. .

+1

, , . Excel, . . , .

0

More articles:


All Articles