Geek asks and answers

Combining Excel files with the same columns into a single excel file using SSIS

Can someone help me how can I merge excel files with the same columns that are stored in the same folder in the same excel target file using SQL Server Integration Services (SSIS).

+3
source share
1 answer

add an Excel source for each of your files as the "union all" task to join them, so if you have 20 lines in your first excel and 30 in the second, you will get 50 lines:

enter image description here

to set the source and destination path, simply double-click each of the tasks and install the connection manager

EDIT:

an example of how to read excel file here

+1

More articles:


All Articles