I am new to SQL Server (Two weeks to be exact). I had no problem finding
documentation on how to create a dts package, but I can not find how to copy
it and reuse it for more then one source. See I have nine databases that are
exactly the same structure and need to import from all nine of them on a
daily basis. Please tell me that there is a simple way to copy an existing
package and modify it to my needs. The package has multiple tasks within it
so copying and pasting on object at a time is not the answer. I hope.

Thank you in advance
Kent Prokopy

Hi Kent,

In the design mode, you can click on "Package -> Save As" option to save
the current package with a new name, thus making a copy of it.

HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.