ssis_t.TblTask_Dft_Step_src - V

type: V ( view ), modify_date: 2021-11-01 13:46:40

RepoObject_guid: 8964FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis_t.tbltask_dft_step_src

Columns

Table 1. Columns of ssis_t.TblTask_Dft_Step_src - V
PK Column Name Data Type NULL? ID

int

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(10)

NULL

varchar(2000)

NULL

int

NULL

varchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis_t.tbltask_dft_step_src

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis_t.tbltask_dft_step_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis_t.tbltask_dft_step_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis_t.tbltask_dft_step_src

Column Reference Diagram

entity_1_1_colref-ssis_t.tbltask_dft_step_src

Column Details

_

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NULL

DFTConnectionManager

DFTConnectionManager

varchar(max)

NULL

DFTRowSet

DFTRowSet

varchar(max)

NULL

DFTSQLCommand

DFTSQLCommand

varchar(max)

NULL

DFTTaskName

DFTTaskName

varchar(max)

NULL

DFTTasksPath

DFTTasksPath

varchar(max)

NULL

DFTTaskType

DFTTaskType

varchar(max)

NULL

DFTTaskType1

DFTTaskType1

varchar(max)

NULL

IsSortedProperty

IsSortedProperty

varchar(10)

NULL

ParameterBindingParameterName

ParameterBindingParameterName

varchar(2000)

NULL

RowID

RowID

int

NULL

Variable

Variable

varchar(max)

NULL

sql_modules_definition

ssis_t.TblTask_Dft_Step_src - V script
/*
ssis_t.TblTask_Dft_Details contails details per each column between data flow task steps

data flow task steps will be extracted here by using select distinct
*/
CREATE VIEW [ssis_t].[TblTask_Dft_Step_src]
As
Select
    Distinct
    ControlFlowDetailsRowID
  , RowID
  , DFTTaskName
  , DFTTasksPath
  , DFTTaskType
  , DFTTaskType1
  , DFTRowSet
  , ParameterBindingParameterName
  , DFTSQLCommand
  , DFTConnectionManager
  , Variable
  , IsSortedProperty
--,[InputQry]
--,[OutputQry]
--,[MultihashcolumnSortPosition]
From
    ssis_t.TblTask_Dft_Details