Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2002
    Location
    pompano beach, FL
    Posts
    8

    Unhappy Unanswered: unable to execute dts's from a bat file

    D:\MSSQL7\JOBS>e:

    E:\UnixBridge>cd \unixbridge

    E:\UnixBridge>DTSRUN /S miasql_dw /E /N DTS_name
    DTSRun: Loading...



    Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)

    Error string: The specified DTS Package ('Name = 'DTS_name'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.

    Error source: Microsoft OLE DB Provider for SQL Server

    Help file:

    Help context: 0

  2. #2
    Join Date
    Apr 2002
    Posts
    23
    Guess your command line call is not correct.

    open a cmd window,
    type "dtsrunui"
    select server and dts package
    run the package correctly
    then click generate command button

    Copy the line and paste into your batch file. It should be fine.
    DTS -> Oracle

  3. #3
    Join Date
    Apr 2002
    Location
    pompano beach, FL
    Posts
    8

    Lightbulb I'm using sql7 server

    Thank you very much for your help. However, since I'm still running sql server 7.0, the "dtsrunui" system file cannot be executed. Do you know the equivalence of it in 7. Thank you in advance.



    Tcharly

  4. #4
    Join Date
    Apr 2002
    Posts
    23
    I read your previous post again and notice you type the command line this way:
    DTSRUN /S miasql_dw /E /N DTS_name

    It should be DTSRUN /S "miasql_dw" /E /N "DTS_name"
    DTS -> Oracle

Posting Permissions

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