SSIS export data to multiple excel file

• deepak.a

  SSCertifiable

  Points: 5330

  More actions

  November 4, 2011 at 2:52 am

  #250359

  Hi All,

  I have a requirenment to export data to multiple excel files based on the employee location in a single ssis package.

  Below is the sample data

  Declare @tblEmp Table

  (

  EmpID Bigint identity(1,1),

  EmpName VARCHAR(50),

  Location varchar(50)

  )

  Insert into @tblEmp values ('Emp 1','Place 1')

  Insert into @tblEmp values ('Emp 2','Place 1')

  Insert into @tblEmp values ('Emp 3','Place 1')

  Insert into @tblEmp values ('Emp 4','Place 2')

  Insert into @tblEmp values ('Emp 5','Place 2')

  Insert into @tblEmp values ('Emp 6','Place 2')

  Insert into @tblEmp values ('Emp 7','Place 3')

  Insert into @tblEmp values ('Emp 8','Place 3')

  Insert into @tblEmp values ('Emp 9','Place 3')

  select * from @tblEmp

  in the above example i have given only few locations but it may have n number of location. can anybody please help me to acheive this in a single ssis package

  Thanks & Regards

  Deepak

• November 4, 2011 at 5:18 am

  This was removed by the editor as SPAM

• deepak.a

  SSCertifiable

  Points: 5330

  More actions

  November 7, 2011 at 12:10 am

  #1403795

  Hi Stewart,

  Thanks for your reply , but the solution is not meeting my requireemnt , i want to generate the separate excel files dynamically for each locations.

  Regards

  Deepak

• November 7, 2011 at 12:28 am

  This was removed by the editor as SPAM

• deepak.a

  SSCertifiable

  Points: 5330

  More actions

  November 7, 2011 at 2:38 am

  #1403815

  Hi stewart,

  Is there anyway we can achieve this using script task or script component ?

  Regards -Deepak

• November 7, 2011 at 3:51 am

  This was removed by the editor as SPAM