Post reply

How can I copy the same package to another server ?

  • September 16, 2004 at 7:30 am

    #59982

    Hi All,

    I have created a Local Package in SQL Server 2000 in my local server.   How can I copy the same package to another server ?  I am not finding anything like 'creating script for table'.  Please Help me

    Bobby

  • September 16, 2004 at 10:07 am

    #523376

    Open the package in DTS Designer.  On the toolbar, click Package then Save As... and put in the name of the other server before clicking OK.

    Greg

    Greg

  • September 17, 2004 at 12:48 am

    #523454

    Or if you can't access the second server from the first

    Package->Save As

    Change the location drop-down to 'Structured storage file'. That way you can save the dts package to the filesystem and move it around as you like.

    On the second server, from ent manager right-click

    Data Transformation Services and select Open package from the menu and find the package in the file system. Then you can Save as and put it back into SQL server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 17, 2004 at 3:01 am

    #523468

    Yes I got it.  Thanks

    Bobby

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply