1
Vote

getting issue in the framework

description

Hi Team,

I have installed CEHF in my environment and getting error while importing a simple text/excel file into database, pasting the error message below, any help in this regard will be highly appreciated.

Error Message

Executed as user: xxx. Unhandled Exception:System.Xml.XmlException: Root element is missing. at CHEFWrapper.Program.WraperCreateSSISPkg(String[] args) at CHEFWrapper.Program.Main(String[] args). Process Exit Code 255. The step failed.

Metadata :

<CHEFMetaData ApplicationName="TestApplication"><Process ID="2800" Name="DemoFlatFileToTable" DefaultAllowTruncate="False" VerboseLogging="False" ExecuteExistingPackage="False"><ConnectionSet><FlatFileConnection key="FlatFileConnection" FileName="G:\PoC\CHEF\Test1.xls" /><SQLConnection key="SQLConnection" ServerName="(local)" DatabaseName="URead" /></ConnectionSet><Step ID="2810" Name="FlatFileToTable Demo" TypeID="1" TypeName="Staging"><DataFlowSet Name="FlatFile" SourceConnection="FlatFileConnection" TargetConnection="SQLConnection" SourceType="FlatFile" TargetType="Table" PickColumnsFromTarget="True" ColumnDelimeter="," RowDelimeter="{CR}{LF}" IsColumnNamesInFirstDataRow="True" RunParallel="True" AllowFlatFileTruncate="False" TruncateOrDeleteBeforeInsert="Truncate" DeleteFilterClause=""><DataFlow Name="TestFile1" SourceName="Sheet1" TargetName="myTable" /></DataFlowSet></Step></Process></CHEFMetaData>

comments

jayantjape wrote Nov 14, 2013 at 4:57 AM

its resolved... there was some issue with the metadata... Thanks for the support.

rjsingh wrote Sep 9, 2014 at 7:31 PM

Thanks Jayant!!!