Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912

    Unanswered: Move DTS package from Server A to Server B

    Hi

    What would you say is the best method to move a DTS package from, say, a test environment to the production server please?

    Thanks muchly
    Testimonial:
    pootle flump
    ur codings are working excelent.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Save it as a file instead of within msdb.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jun 2003
    Posts
    269

    Thumbs up

    DTS best practice,check this link.

    http://vyaskn.tripod.com/sql_server_..._practices.htm
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912

    Brain slowing down... deep thirst... must be F F F F Friday!

    Thanks Blindman

    Had just imported it as you posted - it is nearly the end of the Friday working day for me here - that's my excuse for not googling properly before posting

    You guys across the pond enjoy the rest of your Friday afternoon (working...) - I'm off to play the girly version of Football
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Sep 2003
    Posts
    364
    Check out DTSBackup at sqldts.com

Posting Permissions

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