{{h1}}


{{ published }}
{% for p_name, package_name in project_package_set.items() %}
Project name: {{ p_name }} {% for col_n in project_package_columns %} {% endfor %} {% for package_data_list in package_name %} {% for package_data in package_data_list %} {% endfor %} {% endfor %}
{{ col_n }}
{{ package_data[1] }} {{ package_data[2] }}
{% for project_name, parameter_lists in envs_project_paramters.items() %} {% if (project_name == p_name) %} Project Parameters {% for params in parameter_lists %} {% for param in params %} {% endfor %} {% endfor %}
param name param value parameter reference
{{ param[0] }} {{ param[1] }} {{ param[2] }}
{% endif %} {% endfor %} {% endfor %}

List of Projects per connection


{% for c_name, proj_list_outer in conns_projects.items() %}
Connection name: {{ c_name }} {% for proj_list_in in proj_list_outer %} {% for proj_list in proj_list_in %} {% endfor %} {% endfor %}
project name
{{ proj_list }}
{% endfor %}

List of Enviroments per Project


{% for proj_name, env_list in enviroment_project.items() %} Project name: {{ proj_name }} {% for env in env_list %} {% endfor %}
enviroment name
{{ env }}
{% endfor %}

Parameter details


{% for param_name, project_list in param_projects.items() %}

{% for param_vals in parameters_values %} {% if (param_vals[0] == param_name) %} Parameter name: {{ param_name }}
parameter value parameter reference parameter type key-vault name
{{ param_vals[1] }} {{ param_vals[2] }} {{ param_vals[3] }} {{ param_vals[4] }}
Projects containing the Parameter {% for pack_list_ in project_list %} {% endfor %}
project name
{{ pack_list_ }}
{% endif %} {% endfor %} {% endfor %}

Enviroments details


{% for env_name, envir_details in enviroments.items() %}

{% for build_t in envs_build %} {% if (build_t[0] == env_name) %} Enviroment name: {{ env_name }} - Template group: {{ build_t[1] }} {% endif %} {% endfor %} {% for col in environ_package_columns %} {% endfor %} {% for env_list_in in envir_details %} {% for env_list in env_list_in %} {% endfor %}
{{ col }}
{{ env_list[0] }} {{ env_list[2] }}
{% endfor %} {% for env_name_, proj_list in proj_per_env.items() %} {% if (env_name == env_name_) %} Projects containing the Enviroment {% for pack_list_ in proj_list %} {% endfor %}
project name
{{ pack_list_ }}
{% endif %} {% endfor %} {% endfor %}

Connection details

{% for con_details in connection_details %}
Connection name: {{ con_details[0] }}
server_name database_name provider connection_expression
{{ con_details[1] }} {{ con_details[2] }} {{ con_details[3] }} {{ con_details[4] }}
{% for pr_name, pack_list_outer in conns_packages.items() %} {% if (con_details[0] == pr_name) %} Packages containing connection {% for proj_list_in in pack_list_outer %} {% for pack_list in proj_list_in %} {% endfor %} {% endfor %}
package name
{{ pack_list }}
{% endif %} {% endfor %} {% endfor %}

Package DataFlow details


{% for Df in DF_table %}
Package Name: {{ Df[8]}}

Source connection name: {{ Df[0] }}

Query Space

Is expression: {{ Df[2] }}

Destination connection name: {{ Df[3] }}

Destination schema name: {{ Df[4] }}

Destination table name: {{ Df[5] }}

Truncate Destination ? : {{ Df[6] }}

Use Identity Insert on Destination : {{ Df[7] }}

Use Bulk Copy : {{ Df[9] }}

Batch Size : {{ Df[10] }}

{% for pack_name, proj_list in proj_per_package_DF.items() %} {% if (pack_name == Df[8]) %} Projects containing the Package {% for p_list in proj_list %} {% endfor %}
project name
{{ p_list }}
{% endif %} {% endfor %} {% endfor %}

Package ForEach DataFlow details


{% for FDf in ForEachDF %}
Package Name: {{ FDf[9]}}

Foreach connection name: {{ FDf[0] }}

Foreach Query Expression

Source connection name: {{ FDf[2] }}

Source Query Expression

Destination connection name: {{ FDf[4] }}

Destination schema name: {{ FDf[5] }}

Destination table name: {{ FDf[6] }}

Use Bulk Copy ? : {{ FDf[10] }}

Batch Size : {{ FDf[11] }}

Truncate Destination ? : {{ FDf[7] }}

Use Identity Insert on Destination ? : {{ FDf[8] }}

{% for pack_name, proj_list in proj_per_package_FEDF.items() %} {% if (pack_name == FDf[9]) %} Projects containing the Package {% for p_list in proj_list %} {% endfor %}
project name
{{ p_list }}
{% endif %} {% endfor %} {% endfor %}

Package Execute SQL details


{% for EXSql in ExecSql %}
Package Name: {{ EXSql[4]}}

Source connection name: {{ EXSql[0] }}

Is query an expression: {{ EXSql[2] }}

Execute SQL Expression

Return row count: {{ EXSql[3] }}

{% for pack_name, proj_list in proj_per_package_EXSQL.items() %} {% if (pack_name == EXSql[4]) %} Projects containing the Package {% for p_list in proj_list %} {% endfor %}
project name
{{ p_list }}
{% endif %} {% endfor %} {% endfor %}

Package Execute Process details


{% for EXPr in ExecProc %}
Package Name: {{ EXPr[4]}}

Process executable name: {{ EXPr[0] }}

Working directory name: {{ EXPr[2] }}

Execute Process argument expression

Store Runtime Values in ELT_Framework Database: {{ EXPr[3] }}

{% for pack_name, proj_list in proj_per_package_EXPro.items() %} {% if (pack_name == EXPr[4]) %} Projects containing the Package {% for p_list in proj_list %} {% endfor %}
project name
{{ p_list }}
{% endif %} {% endfor %} {% endfor %}

Package For Each SQL details


{% for FESQL in ForEachSQL %}
Package Name: {{ FESQL[5]}}

Foreach connection name: {{ FESQL[0] }}

Foreach query expression

Query connection name: {{ FESQL[2] }}

Query expression

Return Row Count ? {{ FESQL[4] }}

{% for pack_name, proj_list in proj_per_package_FEEXSQL.items() %} {% if (pack_name == FESQL[5]) %} Projects containing the Package {% for p_list in proj_list %} {% endfor %}
package name
{{ p_list }}
{% endif %} {% endfor %} {% endfor %}

Package JSON table transfer details


{% for JTT in JSONtt %}
Package Name: {{ JTT[5]}}

Source connection name: {{ JTT[0] }}

Table selction option: {{ JTT[1] }}

Flat File Connection: {{ JTT[3] }}

Destination name: {{ JTT[4] }}

Table list
{% for pack_name, proj_list in proj_per_package_JJTS.items() %} {% if (pack_name == JTT[5]) %} Projects containing the Package {% for p_list in proj_list %} {% endfor %}
project name
{{ p_list }}
{% endif %} {% endfor %} {% endfor %}

Package Semi Structured load details


{% for SS in SemiS %}
Package Name: {{ SS[4]}}

Source connection name: {{ SS[0] }}

Destination connection name: {{ SS[1] }}

Destination schema: {{ SS[2] }}

Destination table init option: {{ SS[3] }}

{% for pack_name, proj_list in proj_per_package_SSDT.items() %} {% if (pack_name == SS[4]) %} Projects containing the Package {% for p_list in proj_list %} {% endfor %}
project name
{{ p_list }}
{% endif %} {% endfor %} {% endfor %}