question

pauwnrajpp avatar image
pauwnrajpp asked

Load multiple excels with different structures

Hello Everyone, I have three excel files with different structures. See below. Table : 1 AuditID TransactionID Date Name XXX XYZ Table : 2 AuditID TransactionID Date Name YYY Table : 3 AuditID TransactionID Date Name ZAAA ZBBB ZCCC Output AuditID TransactionID Date Activity Activity_Value The Activity column has all the non-matched column names from the above 3 tables, the Activity_Value column has the values of it. How do i achieve this? The structure of the excel files will be changed on a daily basis. With SSIS foreachloop, we can't achieve this because of non-matched columns of all the excel files. Any other solution for this? Thanks in advance, Pradeep S
sql-server-2012data-warehousedata-importssis excelssis 2012
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg avatar image Oleg commented ·
@pauwnrajpp This looks like a pretty trivial task via openrowset, there is no need to wheel out the for each loop for something like this, assuming that the number of Excel files is the same, just the structure of each file is different. Please post some sample data (few rows from each spreadsheet) and desired output. Thank you.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.