sql server dts: create a DTS package that run for each Table/Query row -- sql server dts

create a DTS package that run for each Table/Query row

clickout c
11/26/2004 8:20:03 AM

sql server dts:

Hi all,
i'll try to explain my problem in the best way!

I'd like to create a DTS package that make a spreadsheet file where each
sheet represents an ubication of objects and contains the list of
objects for that ubication.

In order to obtain this I'm thinking to run 2 queries, the first to
obtain a list of ubications and the second to get the list of objects
for that ubication.
I've created a DTS package to get the list of objects for a specified
ubication but I don't know how to run that package for every ubication.

I apologize for my poor english.

ClickOut

*** Sent via Developersdex http://www.developersdex.com ***

Re: create a DTS package that run for each Table/Query row

Francesco Anti
11/26/2004 5:43:57 PM

you can try a different strategy: look for "lookup query" in BOL.
You can import the ubication, and, in the trasform task you can call a
lookup query that returns the objects for the ubication.
ciao!

[quoted text, click to view]