question

SSGC avatar image
SSGC asked

Do the calculations for two excel files automaticly

I have two excel files. I want to do some calculation for both files then genrated a new excel file. something like: excel file#1: a 1 b 2 c 3 Excel file#2: a 4 b 5 c 6 After automaticly calculation get third Excel file#3 like: a 5 b 7 c 9 Could some one help with this issue? Can I do it in SSIS package? Thank you very much!
ssisexcel
10 |1200

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

1 Answer

·
sunil2711 avatar image
sunil2711 answered
by using derived column transformation
10 |1200

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

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.