ssis - How to include biml file when it has more than one root node? -
i have biml file , want use include directive bring in biml file can reused in other places, keeps giving error when check errors bidshelper:
there multiple root elements
i see examples online of people using include directive no mention on problem. can't find valid element wrap biml in, has chunk.
errorhandling.biml:
<unionall name="union errors"> <inputpaths> <inputpath outputpathname="lookup site.error" /> <inputpath outputpathname="detail level source.error" /> <inputpath outputpathname="site integer.error" /> </inputpaths> </unionall> <derivedcolumns name="error metadata"> <inputpath outputpathname="union errors.output" /> <columns> <column name="execution_guid" datatype="ansistring" length="50" codepage="1252">(dt_str,50,1252)@[user::executionguid]</column> <column name="error_time" datatype="datetime" >getdate()</column> <column name="packageid" datatype="ansistring" length="38" codepage="1252">(dt_str,38,1252)@[system::packageid]</column> <column name="dataflowid" datatype="ansistring" length="38" codepage="1252">(dt_str,38,1252)@[system::taskid]</column> <column name="step_name" datatype="ansistring" length="50" codepage="1252">(dt_str,50,1252)"qi load"</column> <column name="task_name" datatype="ansistring" length="50" codepage="1252">(dt_str,50,1252)"detail level check"</column> </columns> </derivedcolumns>
master.biml snippet:
<rowcount name="row count" variablename="user.checkrowcount"> <inputpath outputpathname="lookup site.match" /> </rowcount> <#@ include file="errorhandling.biml" #> </transformations>
i found 2 ways work- either change extension of file .txt or don't select when "compile" files bidshelper , "check biml errors" or "generate ssis packages". select main files use included files , contain proper xml.
Comments
Post a Comment