I am hoping this is the right forum as the title implies this is for the
older DTS rather than the newer DTSX packages that are part of BIDS. I
extend my apology if this is the wrong forum. If so, please direct me to the
correct forum.

My question pertains to over three hunderd tables that are exported to flat
files daily by our system. Currently they are grouped together in
alphabetical packages - ie, all tables beginning with the letter A are
exported to flat files of the same name, all tables beginning with the letter
B, and so on.

This makes for twenty six working packages and thus 26 schedules to maintain
in the SQL Agent.

I'd like to be able to nest the packages into one single package without
copying over the over three hundren flat file connection managers. The
single package can then be scheduled by the agent. The process is simple and
to date has produced a failed export.

Is there a method to create a dtsx package that NESTS the other dtsx packages?


--
Regards,
Jamie