Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
techguy2006
Starting Member
1 Post |
 Posted - 2010-03-12 : 16:40:13
|
| Hi Experts,I am using Business Intelligence Development Studio, my purpose is to take the data from the AdventureWorks , table HumanResourse.EmployeePayHistory. Then divide the data depends upon the year and send it to the excel sheet to my system, to the specify folder.For example, all the data in the year 1996 will go the excel sheet in the path c:/data/1996/1996data.xlsx and the data of 1997 will go to the path c:/data/1997/1996data.xlsx and so forth...As I am not aware about the year, like it may be start from 1990 to 2009.. Folder should be created dynamically based on the data.Please help me to proceed further. Thanks in advance.Kindly note, I am a newbie in SSIS. |
|
|
|
|
|
Creating SSIS Package