Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    1

    Unanswered: unix to windows.

    Hi, I wanted to connect to windows from a unix script and run a dts package on windows from unix server in a script. Please let me know whether this is possible.

    Thanks
    Nag

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you want to run the DTS package on a Unix machine, it is practically impossible. You may be able to kludge it to work using VM Ware (which is arguably not what you're asking). You might be able to get DTSRUN.EXE to work using one of the migration packages, but this would be a heroic effort.

    The simple answer would be to simply use one of the TDS packages to allow you to connect to the MS-SQL server and use the SQL Agent to run the DTS Package on the MS-SQL server.

    -PatP

Posting Permissions

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