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 job..no other option)
thanks in advance