I have used this reference
http://sqlblog.com/blogs/peter_debetta/archive/2006/07/13/Using-XML-Data-Type-Methods-to-query-SSIS-Packages.aspx
I'm able to achieve packagename, taskname, tasktype,parentnodename,childnodename,level,currentnode,childnode,configurationtype.
Problem - My Package consists of half a dozen sql task & data flow tasks in a single container. After execution of tasks in container, it will call package. Each data flow task consists of source & destination as well, which are not part of the below
table. I also want to know which source & destination will fall under which tasktype?
How do I establish under which taskType which TaskType will come? I want to know relationship between tasktype. How can I figure it out which task will come, under that what will be other task? From level field, I can only find at which level but not able
to figure it out which tasktype. Is it possible can I get 1 and 1.1. and 1.1.1.1 and 2 and 2.1 and...under each object subobjects will be identified in this way.
Note: I have entered only few rows.
Microsoft.SqlServer.Dt.Tasks.Execute....=Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
Packagename | Taskname | TaskType | ParentNodeName | NodeName | level | CurrentNode | ChildNode | ConfigurationType |
test1 | Tax_m | SSIS.Pckage.2 | Tax_m | 1 | some xml | some xml | ||
test1 | Seq_Tax_m | STOCK.SEQUENCE | Tax_m | Seq_Tax_m | 2 | some xml | some xml | |
test1 | Ept_Tax_m | SSIS.ExecutePackageTask2 | Tax_m | Ept_Tax_m | 2 | some xml | ||
test1 | Sql_valid_key_Tax_m | Microsoft.SqlServer.Dt.Tasks.Execute.... | Seq_Tax_m | Sql_valid_key_Tax_m | 3 | some xml | ||
test1 | Sql_Dst_Del_Tax_m | Microsoft.SqlServer.Dt.Tasks.Execute.... | Seq_Tax_m | Sql_Dst_Del_Tax_m | 3 | some xml | ||
test1 | Dft_Tax_M | SSIS.Pipeline.2 | Seq_Tax_m | Dft_Tax_M | 3 | some xml | ||
test1 | Sql_valid_key_TL_m | Microsoft.SqlServer.Dt.Tasks.Execute.... |
Seq_Tax_m | Sql_valid_key_TL_m | 3 | some xml | ||
test1 | Sql_Dst_Del_TL_m | Microsoft.SqlServer.Dt.Tasks.Execute.... | Seq_Tax_m | Sql_Dst_Del_TL_m | 3 | some xml | ||
test1 | Sql_valid_key_TM_m | Microsoft.SqlServer.Dt.Tasks.Execute.... |
Seq_Tax_m | Sql_valid_key_TM_m | 3 | some xml | ||
test1 | Sql_valid_key_TC_m | Microsoft.SqlServer.Dt.Tasks.Execute.... |
Seq_Tax_m | Sql_valid_key_TC_m | 3 | some xml | ||
test1 | Sql_Dst_Del_TM_m | Microsoft.SqlServer.Dt.Tasks.Execute.... |
Seq_Tax_m | Sql_Dst_Del_TM_m | 3 | some xml | ||
test1 | Dft_TL_M | SSIS.Pipeline.2 | Seq_Tax_m | Dft_TL_M | 3 | some xml |
- Moved by Kalman Toth Sunday, November 30, 2014 8:10 PM Not T-SQL