I am creating a DTS package in which I need to create as many excel files using DTS as there are business units in my SQL table. This table has other columns for emplid, emplname and managername. I need to figure out how business units can be used to separate data into different tables and then use DTS to create excel files based on the different business units. I need to be able to loop through the entire table and then move to next table when one Business unit is done without hardcoding the name of the business unit.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS package--- splitting into many excel files
- Thread starter vaichi123
- Start date
jbenson001
Programmer
This sounds like a job for crystal reports not sql. I'm sure it can be done with DTS,but that's really not what it is ment for and it would be easier just to use CR.
jbenson001
Programmer
Also you already posted this in the DTS forum, please post a quetion in only one fourm.
- Status
Similar threads
- Locked
- Question
- Locked
- Question