Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Need advice on designing DTS.. Expand / Collapse
Posted Sunday, August 22, 2010 1:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 2, 2011 12:10 PM
Points: 6, Visits: 27
I have table A with 4000 records(ID is the primary key). I want to develop a DTS package to iterate through the 4000 records in table A pass one id at a time to another task. This task then using the ID will pull dataset dependent on this ID to generate an excel. Overall there needs to be 4000 excels(with data set) for each ID.

Can anyone suggest how to design this using one DTS job? (has to be a DTS other option)

thanks in advance
Post #973094
Posted Thursday, September 9, 2010 8:56 AM



Group: General Forum Members
Last Login: Today @ 1:44 PM
Points: 2,614, Visits: 11,571
As you probably already know, DTS was not made for looping.

I would probably do the looping inside an ActiveX script and have the script call the next step, passing the required information. How, good question.

Alvin Ramard
Memphis PASS Chapter

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help
Post #983190
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse