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 ***
Don't just participate in USENET...get rewarded for it!

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!

"clickout c" <massigazzola (AT) hotmail (DOT) com> wrote