1

Closed

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

description

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 1.6.0.0
 
Thanks
Mike

 

 
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

comments

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.

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.

Thanks
Mike