DTS Jobs - exported?

[Kristin Piskulic]

Can you export a DTS job from a local package to the repository package?

Or

Can you export a DTS job from a server to another server?

Thanks,
Kristin Piskulic

[Gianluca Hotz]

"Kristin Piskulic" <kpiskulic@microcon.com> wrote in message
news:399beff4$1@news.devx.com...
>
> Can you export a DTS job from a local package to the repository package?
>
> Or
>
> Can you export a DTS job from a server to another server?
>
> Thanks,
> Kristin Piskulic

Kristin,
yes just open the package in design mode and choose "Save As" in
the menu.

HTH
--
Gianluca Hotz
Backoffice MVP (SQL Server) MCP SQL Server and MCP Windows
Founding member of the Italian User Group for SQL Server
http://www.ghotz.com
http://www.ugiss.org

[D. Patrick Hoerter]

Kristin,

Just beware, when you go from server to server. The connections don't
fix themselves automatically, unless you referenced 'local' for the server,
or you have added an ActiveX task that fixes the connections based upon
global Package variables. Also, if you reference 'local', the package will
only run when you are actually _on_ the server machine.

Regards,
D. Patrick Hoerter

Gianluca Hotz wrote in message <399bffdd@news.devx.com>...
>"Kristin Piskulic" <kpiskulic@microcon.com> wrote in message
>news:399beff4$1@news.devx.com...
>>
>> Can you export a DTS job from a local package to the repository package?
>>
>> Or
>>
>> Can you export a DTS job from a server to another server?
>>
>> Thanks,
>> Kristin Piskulic
>
>Kristin,
>yes just open the package in design mode and choose "Save As" in
>the menu.
>
>HTH
>--
>Gianluca Hotz
>Backoffice MVP (SQL Server) MCP SQL Server and MCP Windows
>Founding member of the Italian User Group for SQL Server
>http://www.ghotz.com
>http://www.ugiss.org
>
>
>
>