Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 cluster - Copy All SSIS Packages to Disk Expand / Collapse
Author
Message
Posted Wednesday, December 11, 2013 2:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 4:40 AM
Points: 375, Visits: 924
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?
Post #1521783
Posted Wednesday, December 11, 2013 2:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 5,078, Visits: 8,923
Have you tried explicitly specifying the server with the SourceServer parameter?

John
Post #1521785
Posted Wednesday, December 11, 2013 2:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 4:40 AM
Points: 375, Visits: 924
Yes. That thought stuck me too. treid. It Wroks like charm.

Post #1521786
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse