ETL and Data Integration tools - Modern ETL software for everyone

I have now built scores of packages and more are in the planning stages. Would it be possible to introduce a way to have folders within the dropdown lists in the left window so that the packages can be organized in a way that will make them easier to manage? For instance, I'd like to have a folder for each customer I'm working with so that I can keep their various packages grouped together. I've been naming them such that they fall together in the list, but my list is getting unweildy. This might be nice for the imports as well, but that is less vital since they are already grouped by connection. However, all of the packages fall together into a single list. As always, thanks for your help.

(p.s. after posting to this new thread I realized I should have probably put this into suggestions. Sorry about that. Maybe a moderator could move it?)

Kenneth.

Please download verson 7.3.5.
We did it in slightly different way that you suggested,
There is no cateories but you can group packages together using mouse

Mike

OK, I had to play with it a little bit before I saw how to use this, but now i think I've got it. I have two questions.

First, could the various items in the object tree start out closed or at least how they were the last time I worked with them. Grouping the packages allows me to reduce the number of packages in the display by hitting the '-' box to close up the list which has been grouped together. However, if all of the groupings are open when I start up the program then I have to spend a little time just closing boxes in order to realize this simpler view of the various objects.

Second, I seem to have made a mistake. As I was dragging one of my group packages around to put it under my driver package I let go of the left button at an inopportune moment when I was hovering over the group I was trying to move. In other words, I tried to move it on top of itself thus making it a part of itself in the list. Since its link to its parent points back to itself it has disappeared from the display along with the packages I had already grouped under it. I was able to fix this by updating the OBJECTS_TREE table to set the PARENT_ID column to what I really wanted it to be. However, you might want to try to protect me from myself and recognize this action as a null action (no changes) rather than having it point to itself.

I haven't tried it but I suspect it might be possible to create other problems if I tried to group a parent package under one of its child (or grandchild) packages. I haven't tried this so that I don't have to try to fix the table pointers again.

Thanks again. I really appreciate your help in adding this new feature.

Well, I ran into a problem after getting my driver package reorganized in the object list so that all of the various packages which are included within the execution of the package are also displayed as subordinate to the driver package. The package execution operation can't seem to find the subordinate packages. The execution log simply shows the outer package beginning and then ending with no steps within the subordinate package being executed. Time for another fix? The organizing capability is useless if the packages so organized cannot be run.