workflow.Biml_Project - V
type: V ( view ), modify_date: 2022-09-08 16:18:58
RepoObject_guid: B166A0A8-E3FA-EB11-850E-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
sql_modules_definition
workflow.Biml_Project - V script
CREATE View workflow.Biml_Project
As
Select
Project_Biml = Concat (
'<Biml xmlns="http://schemas.varigence.com/biml.xsd">
<Projects>
<PackageProject Name="SSIS_EventAnalytics_v2">
<Packages>
'
, String_Agg (
Cast('<Package PackageName="' As NVarchar(Max)) + T2.Package_Name + '" />'
, Char ( 13 ) + Char ( 10 )
) Within Group(Order By
T2.Package_Name)
, '
</Packages>
<Connections>
'
, Max ( T1.ConnectionName_Biml )
, '
</Connections>
</PackageProject>
</Projects>
<Connections>
'
, Max ( T1.ConnectionString_Biml )
, '
</Connections>
<Packages>
'
, String_Agg ( Cast(T2.Package_Biml As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
T2.Package_Name)
, '
</Packages>
</Biml>
'
)
From
workflow.Biml_Connection As T1
, workflow.Biml_Package As T2