There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
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 220.127.116.11
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