Post reply

SQL 2008 cluster - Copy All SSIS Packages to Disk

  • December 11, 2013 at 2:30 am

    #287351

    On windows 2008 clustered sql am running below command to move a package from msdb to folder in another server.

    dtutil /SQL "TESTPACKAGE" /COPY FILE;"\\SERVER\SSIS\TESTPACKAGE".dtsx

    Error:

    Error (0x80004005) getting package "TESTPACKAGE" from SQL Server.

    Description: Named Pipes Provider: Could not open a connection to SQL Server [2].

    Same query works in non-clsutered sql. How to resolve this?

  • December 11, 2013 at 2:40 am

    #1672531

    Have you tried explicitly specifying the server with the SourceServer parameter?

    John

  • December 11, 2013 at 2:44 am

    #1672532

    Yes. That thought stuck me too. treid. It Wroks like charm.

    🙂

Viewing 3 posts - 1 through 2 (of 2 total)

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