How to deploy a SSIS package to the MSDB via DTUTIL?
Hello All, Im trying to deploy a SSIS package via the DTUTIL. When I execute the below script via the CMD DTUTIL /FILE "C:\SSISPACKAGE\TEST.dtsx" /COPY SQL;TEST /QUIET I get the below error: Could not save package TEST because of the error 0x80004005. Description: Named Pipes Provider: Could not open a connection to SQL Server [2]. Source: Microsoft SQL Server Native Client 10.0 Ive just installed SSIS on this machine; do I need to configure it in any kind? Thanks.
May 23rd, 2012 4:48pm

What version of SSIS? do you use? If SSIS 2012 then yes, it requires tweaking. It must be this KB article that helps to connect: http://msdn.microsoft.com/en-us/library/aa337083.aspx Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2012 5:02pm

Thanks for the response ArthurZ the SSIS version is 2008 R2.
May 24th, 2012 7:17am

What if you add /DestServer <servername>?MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
May 24th, 2012 7:20am

make sure that dts service is started and tcp/ip and named pipe is enabled
May 25th, 2012 8:19am

make sure that dts service is started Why?MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2012 8:21am

ssis requires dts service to be enabled... as it is just an extension of old dts to dtsx.
May 25th, 2012 8:29am

ssis requires dts service to be enabled... as it is just an extension of old dts to dtsx. Euhm... no. SSIS is not an extension of DTS, it is an entirely new product. And the service certainly doesn't need to be running.MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2012 8:33am

Thanks for the response ArthurZ the SSIS version is 2008 R2. Then it is most probably a config problem. Can you connect to the SQL Server using SSMS? Probably you will not be able. Perhaps the SQL Server service is not started. Arthur My Blog
May 25th, 2012 8:38am

Rohitz, where would I find the dts service? Do you mean "SQL Server Integration Services 10.0" service? Koen, at what point would I add the "/DestServer <servername>" to my script? Thanks.
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2012 8:39am

sorry i mentioned dts, its dtc... Distributed Transaction Coordinator
May 25th, 2012 8:39am

sorry i mentioned dts, its dtc... Distributed Transaction Coordinator That makes more sense. But you only need that service for running transactions inside SSIS, not for deploying packages.MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2012 8:42am

Koen, at what point would I add the "/DestServer <servername>" to my script? Thanks. An example (taken from the MSDN page): dtutil /FILE c:\sourcepkg.dtsx /DestServer <servername> /COPY SQL;destpkgname MCTS, MCITP - Please mark posts as answered where appropriate.
May 25th, 2012 8:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics