ssis_t.TblTask_Sql_src - V

CREATE VIEW [ssis_t].[TblTask_Sql_src]
As
Select
    cf.RowID
  , cf.ControlFlowDetailsRowID
  , SqlConnection      = cfnodes1.x.value (
                                              'declare namespace SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask";
					/SQLTask:SqlTaskData[1]/@SQLTask:Connection'
                                            , 'uniqueidentifier'
                                          )
  , SqlStatementSource = cfnodes1.x.value (
                                              'declare namespace SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask";
					/SQLTask:SqlTaskData[1]/@SQLTask:SqlStatementSource'
                                            , 'nvarchar(max)'
                                          )
From
    ssis_t.TblControlFlow                   As cf
    Cross Apply Cf.SqlTaskQry.nodes ( '.' ) As cfnodes1(x)

sqlCopied!