SSIS Project build failing in TeamCity but succeeding in Visual Studio

Hi,

I have multiple SSIS Projects that I am building in TeamCity however they are failing with the errors that I will list at the bottom of my post. The projects build fine in Visual Studio on the same server as the TeamCity build.

I am using Visual Studio 2013 with SQL Server 2014 and Visual Studio Online as my source control.

Any assistance will be much appreciated :)

It seems that a single package is failing for each of my SSIS projects (the first package in each project's directory so likely just failing on the first package it gets to)

 

Step 1/2: Build SSIS Projects (MSBuild) (7s)

[08:36:37][Step 1/2] Dev\BPM DW\SSISBuild.proj.teamcity: Build target: SSISBuild (5s)
[08:36:37][Dev\BPM DW\SSISBuild.proj.teamcity] SSISBuild (5s)
[08:36:37][SSISBuild] DeploymentFileCompilerTask (5s)
[08:36:38][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): Error while loading package '.\ETL.BISystem\MetaData.Database.dtsx': The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
[08:36:38][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.LoadPackage(String path) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.Execute()
[08:36:39][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): Error while loading package '.\ETL.DataQuality\DataQuality.Process.dtsx': The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
[08:36:39][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.LoadPackage(String path) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.Execute()
[08:36:39][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): Error while loading package '.\ETL.GlobalProcess\GlobalProcess.FileManager.dtsx': The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
[08:36:39][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.LoadPackage(String path) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.Execute()
[08:36:40][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): Error while loading package '.\ETL.OLAP\DimensionProcessing.dtsx': The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
[08:36:40][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.LoadPackage(String path) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.Execute()
[08:36:41][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): Error while loading package '.\ETL.StageToClean\Clean.Template2.dtsx': The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
[08:36:41][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.LoadPackage(String path) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.Execute()
[08:36:41][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): Error while loading package '.\ETL.UnitTest\ExecuteTests.dtsx': The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
[08:36:41][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.LoadPackage(String path) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.Execute()
[08:36:42][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): Error while loading package '.\ETL.Warehouse\Warehouse.FactOrderTemplate.dtsx': The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
[08:36:42][DeploymentFileCompilerTask] C:\TeamCity\buildAgent\work\7ddb4b7d197c82ba\Dev\BPM DW\SSISBuild.proj(28, 5): The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.LoadPackage(String path) at Microsoft.SqlServer.IntegrationServices.Build.DeploymentFileCompilerTask.Execute()
[08:36:42][Step 1/2] Step Build SSIS Projects (MSBuild) failed

 

 

1 comment

Hello James,

Could you please try to run the same project via command line (using MSBuild.exe) on TeamCity agent machine in the checkout directory under the same user that the agent is running under? Does the build run successfully?

0

Please sign in to leave a comment.