I am attempting to implement the Project Real BI solution (http://www.microsoft.com/sqlserver/2005/en/us/project-real.aspx)
It is designed for 2005. I am running two instances of SQL Server:
1. 2005 (default instance) 2. 2008 (named instance)
AS 2005 is not installed, AS 2008 is.
I have been able to get the source transactional and DW up on my SQL2005 instance. And have implemented the cube onto my AS 2008 instance. However, when i run the SSIS packages it fails when it gets to the AS_Dim_Process_MT.dtsx package - with the following
[Execute Process Task] Error: In Executing "C:\Microsoft Project REAL\ETL\ETL\ascmd.exe" " -S "(local)" -d "REAL Warehouse Sample V6 MT" -v maxparallel=6 ProcessType=ProcessUpdate
-i "C:\Microsoft Project REAL\ETL\ETL\Dim_64bit.xmla" -T "C:\Microsoft Project REAL\ETL\ETL\Dim_process_trace_20100915_165920.csv" -Tl low " at "C:\Microsoft Project REAL\ETL\ETL", The process exit code was "1" while the expected was "0".
I am guessing it has something to with either:
1. ascmd.exe and it's compatibility with 2008, or
2. the XMLA and it's compatibility with 2008?
Also, in the project real directory there is also a Dim_32bit.xmla which i think it should be picking up (i am on 32 bit).
Any assistance greatly appreciated.
View Complete Post