November 4, 2011 at 2:52 am
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 7, 2011 at 12:10 am
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 2:38 am
Hi stewart,
Is there anyway we can achieve this using script task or script component ?
Regards -Deepak
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy