SQL Server Performance

Import or export the packages

Discussion in 'SQL Server 2005 General Developer Questions' started by Varsha, Mar 23, 2008.

  1. Varsha New Member

    Hi,
    I want to export the packages from one server to another in the dts format. For packages we dont have any option like import or export. is there any tool which or script which would help in doing that.
  2. ghemant Moderator

    Hi,
    just open a package in DTS Designer -> Save As -> name it -> location (another server) and you are done.
  3. Varsha New Member

    I know this way but this way you can import only one package at a time. We have around 200 packages and moving it one by one would be a tedious job. So o wanted to know if there is a way we can import everything(all 200 packages) at a single shot.
  4. ghemant Moderator

Share This Page