1

Closed

Error Deploying package

description

BIDS Helper is deploying packages...
Deploying to SSIS Package Store MSDB on server LVEDWDV01
Deploying to folder: Core First Run

Error : BIDS Helper encountered an error when deploying package applsys_fnd_lookup_values.dtsx!
"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\binn\dtutil.exe" /FILE "C:\Datawarehouse\Revenue\Development\Releases\1.0.0\Staging\SSIS\Full\Stage_Core\applsys_fnd_lookup_values.dtsx" /DestServer LVEDWDV01 /COPY DTS;"MSDB\Core First Run\applsys_fnd_lookup_values" /Q
exit code = 6
Microsoft (R) SQL Server SSIS Package Utilities
Version 10.50.1600.1 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.

Could not create SSIS Service Storage object because of error 0x800706BA.
Description: The RPC server is unavailable.
Closed Apr 7, 2013 at 1:43 AM by furmangg
No response and BIDS Helper is just calling dtutil as configured

comments

furmangg wrote Mar 19, 2013 at 3:00 PM

As you can see, it's just running dtutil.exe. So it appears BIDS Helper is doing what you're telling it to do correctly.

But maybe we can troubleshoot. If you open Management Studio, can you connect to SSIS on LVEDWDV01?

If you change the BIDS Helper Deploy options to DestinationType=SqlServerDestination does it work then? The options that start with SsisPackageStore*** cause different parameters to be passed to dtutil.exe. I've found SqlServerDestination more reliable and less prone to problems with different environment configurations.