Results 1 to 3 of 3

Thread: DTS change owner

  1. 06-19-2001, 08:33 AM #1
    LMYDev Guest

    DTS change owner

    I need to transfer a dts package to another server and change the owner to the database owner of the other server. I transfer the dts package using the
    "save as.." menu option of the dts designer but I don't know how to change the owner.
    Thanks for your help in advance.
    Reply With Quote Reply With Quote
  2. 06-19-2001, 10:34 AM #2
    MAK Guest

    DTS change owner (reply)


    save the DTS package as a file.
    login to new server as u.
    restore the dts package and save as new dts package.

    -MAK

    ------------
    LMYDev at 6/19/01 9:33:14 AM

    I need to transfer a dts package to another server and change the owner to the database owner of the other server. I transfer the dts package using the
    "save as.." menu option of the dts designer but I don't know how to change the owner.
    Thanks for your help in advance.
    Reply With Quote Reply With Quote
  3. 06-21-2001, 08:46 PM #3
    LMYDEV Guest

    DTS change owner (reply)

    Thank you!!!
    It worked!


    ------------
    MAK at 6/19/01 11:34:40 AM


    save the DTS package as a file.
    login to new server as u.
    restore the dts package and save as new dts package.

    -MAK

    ------------
    LMYDev at 6/19/01 9:33:14 AM

    I need to transfer a dts package to another server and change the owner to the database owner of the other server. I transfer the dts package using the
    "save as.." menu option of the dts designer but I don't know how to change the owner.
    Thanks for your help in advance.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules