Requirement - My boss asked me to create a document that contains all components in the package. I should build a solution using .net or some other way. This document should contain all components along with the properties. Could someone help me on this. I'm able to find some info from this website...I cannot buy a product.

http://sqlage.blogspot.in/2013/07/ssis-read-ssis-package-filedtsx-for.html

Use http://pragmaticworks.com/Products/BI-Documenter

Documenting is tedious otherwise.

I'm sorry, I have to build these. I cannot buy a tool.

Hi kdinuk,

SQL Server doesnt provide a SSIS Package document tool natively. As a work round, you can use T-SQL to parse the XML code in the .dtsx file, or make use of script task to retrieve detailed information from a .dtsx file:

• http://sqlblog.com/blogs/jamie_thomson/archive/2009/10/18/collecting-information-about-your-ssis-packages-ssis-nugget.aspx 
• http://sqlage.blogspot.com/2013/07/ssis-read-ssis-package-filedtsx-for.html 

Regards,

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.

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

• Edited by kdinuk Tuesday, November 11, 2014 7:13 PM

Can someone pls help me on this?

Can someone pls help me on this?

Not sure what to help with and one more thing: since the post has been marked as answered please either create a new one or unmark a reply as the answer.