DTSRUN failure

  • Plse help i am experiencing

    the following error message occurs when doing dtsrun from command line:

    Error: -2147467259 (80004005); Provider Error: 6 (6)

    Error string: [DBNMPNTW]Specified SQL server not found.

    Error source: Microsoft OLE DB Provider for SQL Server

    Help file:

    Help context: 0

  • What are you entering at the command line?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • dtsrun /s eminem\csdi /n musicamqtrigger /E

    The server from which i am executing this statement has NT4 & SQL7 server installed. The Host is a SQL2k SP3 server.

    I am able to execute this with no probs from a w2k + sql7 server.

    quote:


    What are you entering at the command line?

    Cheers,

    - Mark


  • try this:

    path to.. dtsrun" /Server_name/user_name/P password/N name of DTS/G unique id in{} of the DTS

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply