Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    20

    Unanswered: minimum req files for a desktop to use DTS?

    Hey all,
    I have an operator who needs to be able to run a dts package, but I do not want to give them Enetrprise Manager. Is it possible to just install the objects needed to run DTS?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Give them osql.exe, create a bat that executes the package...

    make sure you can connect and execute with something other than sa, because you'll have to hard code the is and pwd...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    You can write a little vb app to execute the package or just schedule it.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Look at dtsrun.exe or dtsrunui.exe.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by rnealejr
    Look at dtsrun.exe or dtsrunui.exe.
    No kidding...

    Good one for the memory banks...

    I avoid DTS for the most part...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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