Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    3

    Red face Unanswered: Can i run DTS package on net

    Dear sir
    can i run .dts file through command prompt utility dtsrun.exe , evenif my computer doesnt have Sql server install

    if yes pls tell me how

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by pari_shelar
    Dear sir
    can i run .dts file through command prompt utility dtsrun.exe , evenif my computer doesnt have Sql server install

    if yes pls tell me how
    To be honest, I don't know. But here are some things you can try:

    1. You would need to have at least a client install of SQL Server tools. Look for dtsrun.exe on your local machine; if it's not there, then you can stop because you won't be able to go further.

    2. You can try executing the DTS using SQL DMO, but in this case, you will be calling the package on the remote (SQL Server) which is not how you phrased the question.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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