dtutil error code -532459699
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
July 26th, 2012 12:18pm

Can anybody help??? really up sh*ts creek without a paddle.
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 2:36pm

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
July 26th, 2012 4:08pm

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?
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 5:35pm

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.aspxPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
July 27th, 2012 2:22am

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
Free Windows Admin Tool Kit Click here and download it now
July 27th, 2012 2:51am

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
July 27th, 2012 4:23am

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
Free Windows Admin Tool Kit Click here and download it now
July 27th, 2012 9:42am

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.
July 27th, 2012 9:49am

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

Other recent topics Other recent topics