workflow.Biml_Project - V

type: V ( view ), modify_date: 2022-09-08 16:18:58

RepoObject_guid: B166A0A8-E3FA-EB11-850E-A81E8446D5B0

Description

Examples

Entity Diagram

entity-workflow.biml_project

Columns

Table 1. Columns of workflow.Biml_Project - V
PK Column Name Data Type NULL? ID

nvarchar(max)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-workflow.biml_project

References

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.biml_project

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.biml_project

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.biml_project

Column Reference Diagram

entity_1_1_colref-workflow.biml_project

Column Details

_

Project_Biml

Project_Biml

nvarchar(max)

NOT NULL

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