question

rajiv1mehrau avatar image
rajiv1mehrau asked

Grouping through SSIS

Hi all I have to do a task in daily basis. I got some excel files in a folder. Let me explain you. Suppose in a particular folder i have 30 excel files with same data in a group of 10 excel files. For example 10 excel files (around 1 lakh data in total of 10 excel files) out 30 i have same data like SrNo, Name, PhoneNumber. Another 10 files (around 1 lakh data in total of 10 excel files) i have same data like SrNo, A/c, role. Another 10 files (around 1 lakh data in total of 10 excel files) i have same data like SrNo, dpt, total. Finally i have to make only 3 excel files having same data. Can i perform this task through SSIS or there is any other option. Please help me out. Many thanks in advance. Rajiv.
files
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

·
iainrobertson avatar image
iainrobertson answered
You can indeed achieve this with SSIS. Although it isn't the most elegant of tasks and it can't do formatting. You will need to set up: A for...loop container using an excel connection manager to iterate over the source files: http://msdn.microsoft.com/en-us/library/ms345182.aspx An excel destination component to receive the data: http://msdn.microsoft.com/en-us/library/ms137643.aspx I can't remember off the top of my head whether you can configure this to append to the existing data, so you'll need to find this out.
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.

thanks iain let me try.....
0 Likes 0 ·

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.