Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Question Unanswered: Save DTS packages to MSDE

    Hi,
    I'm new to SQL Server. And I have problem moving the DTS packages from SQL server standard edition to MSDE. Is there other way to save the DTS package without access to the Enterprise Manager? And what about ways to edit the DTS packages loaded into MSDE so that it can run properly on the new server?
    Thanks.

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Why not save the packages as files then you don't have any problems.

    Does msde include the dts application?

    Note that dts is a client application not part of the server.
    It can load and run packages which may be stored in a database or in files and create connections to servers to manipulate data.

  3. #3
    Join Date
    Feb 2003
    Posts
    2
    The MSDE does come with the dtsrun utility.
    So, you mean, if I save the DTS packages from SQL Server 2000 as .dts files, I can run the DTS packages from the .dts files? I think we have to save the .dts into the DTS service in MSDE first?

    And another question that may arise is, how to edit the DTS package to make it run smoothly on another server without Enterprise Manager? Any suggestion?
    Thanks...

  4. #4
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    OK if the dts client is installed then you just need to load the package and run it.
    The /F parameter on dtsrun will load the file and run it.

    You can also use sp_oacreate which will allow you to change properties of the package before running it.
    This will enable you to do anything you did with enterprise manager but not as easily. Save the package afterwards or you can use it to run the package and make any changes on every run.
    Probably better to use it to set global variables and use them within the package.

    see
    www.nigelrivett.com
    sp_oacreate Load DTS

Posting Permissions

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