dtutil error code -532459699

Question

Hi all,

We getting the below error when using dtutil to deploy SSIS packages to integration services on another server.

dtutil.exe /FILE "PackageXYZ.dtsx" /DestServer ABC /COPY SQL;"FolderX\PackageXYZ" /Q " exited with code -532459699.

what does this error code mean?

thanks

Answer 1

Can anybody help???

really up sh*ts creek without a paddle.

Answer 2

the easiest way to deploy a ssis package to a sql server is the 'Save Copy of package option'. if it is missing in your BIDS, you can check this link :http://stackoverflow.com/questions/3294012/ssis-save-copy-of-missing-in-my-visual-studio-2008

then you just need to provide the sql server name, name of the package and the type of authentication you want. normally Rely o server storage is good option.

regards

joon

Answer 3

We can't use visual studio as part of CI environment, where we are deploying SSIS packages from msbuild.

thanks for replying though.

Any ideas Microsoft?

Answer 4

1) is it for all packages?
2) try it without the quotes " (msdn examples are all without)
3) go to microsoft connect and ask for a list of all exit codes for dtutil simular to this list of SSIS errorcodes: http://msdn.microsoft.com/en-us/library/ms345164.aspx

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 5

1) is it for all packages?
2) try it without the quotes " (msdn examples are all without)
3) go to microsoft connect and ask for a list of all exit codes for dtutil simular to this list of SSIS errorcodes: http://msdn.microsoft.com/en-us/library/ms345164.aspx

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 6

Hi Jaq1t..

Use this Code for creating bat file..

SET ServerName=%1
SET SourcePath=%2
SET MSDBFolder=%3

@Echo Off

Echo.
Echo.
Echo Deployment Server: %1
Echo -----------------------------------------------------
Echo --This will delete any %3 data mart files
Echo --on the server, and reinstall from the local machine
Echo -----------------------------------------------------
Pause
REM Goto Out

REM Remove Existing files and directory on Server
for %%f in (%SourcePath%\*.dtsx) do (
Echo
Echo Now Removing: %%~nf

dtutil /Q /SourceS %1  /SQL "%3\%%~nf" /Del

 

)

dtutil /Q /SourceS %1 /FDe "SQL;\;%3"

:Create

Echo.
Echo Preparing to create folder
Echo.
pause

REM Create the Directory
dtutil /Q /SourceS %1 /FC "SQL;\;%3"
if errorlevel 1 goto End
Echo.
Echo Preparing to Copy Files to Server
Echo.
pause

:Out
REM copy the SSIS Packages to the server
for %%f in (%SourcePath%\*.dtsx) do (
Echo Now Copying: %%~nf
dtutil /Q /DestS %1 /File "%%f" /Copy SQL;"%3\%%~nf"
)

Goto End

:End

Answer 7

Hi SSISJoost,

1) It is only for some packages and all very sporadic, problem is it's in our CI environment and is holding up release of code to live.

2) I'll try without quotes 

3) Submitted a connect item asking for an explanation of the error code https://connect.microsoft.com/SQLServer/feedback/details/755765/returned-dtutil-error-code-is-meaningless

Thanks

Jag

Answer 8

Hi SSISJoost,

1) It is only for some packages and all very sporadic, problem is it's in our CI environment and is holding up release of code to live.

2) I'll try without quotes 

3) Submitted a connect item asking for an explanation of the error code https://connect.microsoft.com/SQLServer/feedback/details/755765/returned-dtutil-error-code-is-meaningless

Thanks

Jag

If it's not for all packages then it's probably not the quotes. Examine the packages that wont deploy and check for simularities between them...

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 9

its an exception from the com. May be you have to dig into your system to see if there is any component missing or not running:

http://stackoverflow.com/questions/9164050/whats-the-significance-of-532459699

there is no specific explanation for this error.