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