CODEWITHSUNDEEP
business-intelligencessis
Vikas Kunte
Vikas Kunte

Reputation: 731

Merge Excel files having same columns into one excel file using SSIS

Can any one help me out how can i merge excel files having same columns which are saved in one folder to one destination excel file using SQL Server Integration services(SSIS) .

Upvotes: 3

Views: 3762

Answers (1)

Diego
Diego

Reputation: 36176

add an Excel source for each of your files an a "union all" task to join them, so if you have 20 rows on your first excel and 30 on the second, you will end up with 50 rows:

enter image description here

to set the source and destination paths, just double click each of the tasks and set the connection manager

EDIT:

example of how to read an excel file here

Upvotes: 1

Related Questions