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.
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.
15 People are following this question.
