Fail to build SSIS/SSAS projects via VS2012 command line (devenv.exe) with SSDT BI tool installed - by Jimmy Jin

Status : 

 


11
0
Sign in
to vote
ID 781872 Comments
Status Closed Workarounds
Type Bug Repros 8
Opened 3/21/2013 2:53:46 PM
Access Restriction Public

Description

I installed recently released SSDT BI tools for VS2012 and I can work on my existing SSIS/SSAS projects all well in VS2012, including build, deploy and process SSAS cubes, etc.

But when I try to build my SSIS/SSAS projects via the command line of VS2012, such as

devenv.exe mySolution.sln /rebuild Release /out "C:\temp\buildLog.txt"

I will get the error like below in the log file.

Error: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))

I can do that with VS2010 with the BI tools installed with SQL Server 2012.

I'm on Windows 7 Enterprise 64-bit, and I have both VS2010 and VS2012 installed at the same time, together with SQL Server 2012 developer edition.
Sign in to post a comment.
Posted by DS19 on 6/19/2014 at 1:35 AM
I had the same error during the SSIS build and I installed SSDT-BI for VS2012 11.0.3402.0 and now it is working.
Microsoft Visual Studio Premium 2012
Version 11.0.61030.00 Update 4
SQL Server Data Tools 11.1.40403.0
Posted by RKilkenny on 5/29/2014 at 10:12 AM
I'm running VS2012 Professional Update 4 (11.0.61030.00) - and its working, but i'm also running VS2012 Shell (Integrated) Update 4 (11.0.61030.0 Q11Rel) on another machine and it gives the Catastrophic Failure message.
Posted by Phil Austin on 4/4/2014 at 11:02 AM
I get two different errors using SSDT version 11.1.31203.1 - a later version than the version linked to below. On my local machine (Win 8) I get;

The system can not find the file specified.
The operation could not be completed. The parameter is incorrect.

On a Server 2008 R2 I get;

Error: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))

Using the same command line.
Posted by DS19 on 1/28/2014 at 10:17 AM
I have the same error when I try to build my SSDT-BI projects from command line; I have VS2012 Update 4, SSDT-BI and SSDT January 2014 update.
Posted by Randy Farmer on 8/6/2013 at 9:56 PM
Kasper, I've installed the latest SSDT on my local dev box and on my build servers, and I still get the same error when trying to /deploy SSRS projects from the command line. /build works, but /deploy crashes
Posted by Kasper [MSFT] on 6/8/2013 at 9:10 PM
This is fixed with the lastest version of SSDT that you can download here:
http://www.microsoft.com/en-us/download/details.aspx?id=36843

Regards,
Kasper de Jonge
Analysis Services team
Posted by Richard Fennell [MVP] on 4/24/2013 at 7:41 AM
I have seen the same problems with VS2012.2

the workaround of using VS2010 for the command line build seems to have worked for me
Posted by mbaker000 on 4/23/2013 at 5:08 AM
Same issue here. We can't hook this up to any sort of CI until we can build on the command line.
Posted by Puneet Warikoo on 4/17/2013 at 5:19 AM
I am using Windows 8 instead of Windows 7
Posted by Puneet Warikoo on 4/17/2013 at 5:17 AM
I am also getting the same error. I need to automate the build generation for SSIS and this seems to be the only way.
Posted by gcatton on 4/8/2013 at 9:15 AM
Have same issue with same setup as above