This project has moved. For the latest updates, please go here.


SSIS Deploy package - sending 2012 pacakge to SSIS 2008 R2 throws error 0x80040154


If I use the SSIS Deploy functionality to try to send an SSIS package in SQL 2012 format to a Server running only SSIS 2008 R2, an error results, see below for an example.
I realise this is not a valid deployment scenario, but perhaps this could be trapped and a more informative message presented?
I'm using SQL 2012 / VS2010, with BIDS Helper


Error : BIDS Helper encountered an error when deploying package import UBS.dtsx!
"C:\Program Files (x86)\Microsoft SQL Server\110\DTS\binn\dtutil.exe" /FILE "\car21dev\DataWarehouse\DailyImporter\SSIS Packages\UBS Import\import UBS.dtsx" /DestServer car21 /COPY DTS;"MSDB\DailyImporter\import UBS" /Q
exit code = 6
Microsoft (R) SQL Server SSIS Package Utilities
Version 11.0.2100.60 for 32-bit
Copyright (C) Microsoft Corporation 2012. All rights reserved.
Could not create SSIS Service Storage object because of error 0x80040154.
Description: Class not registered


Closed Aug 22, 2012 at 10:48 PM by furmangg
the error message comes from dtutil


furmangg wrote Aug 22, 2012 at 10:48 PM

We're just surfacing the dtutil error and can't really do better than that.

By the way, it looks like you're using a SsisPackageStoreMsdbDestination destination. If you try SqlServerDestination will it work? I haven't tried it, but it may be worth a shot... though like you said, this isn't a valid deployment scenario.

wrote Aug 22, 2012 at 10:48 PM

MikeHoney wrote Aug 23, 2012 at 6:23 AM

Hi Greg,

Thanks for looking into this so quickly. I'll try and repro it with dtutil and raise it on Connect.

Actually I didnt want it to work, just a clearer error message about why it was failing.


wrote Feb 22, 2013 at 1:41 AM

wrote May 16, 2013 at 12:56 PM