locked
How to get names of Data Flow Tasks for each Package RRS feed

  • Question

  • I need to generate a list where I get all the names of my Data Flow Tasks for each package.

    Or just list of all Data Flow Tasks for a particular Package.


    How do i achieve this.

    Thanksss
    Friday, September 18, 2009 4:43 PM

Answers

  • Where are your packages stored?

    You could probably use the SSIS API to traverse through them, or you can parse the XML of the .dtsx file.  Either way, I don't know of an easy out-of-the box method to do this.

    Phil Brammer | http://www.ssistalk.com
    • Marked as answer by Sonic.Jessy Sunday, September 27, 2009 1:40 AM
    Friday, September 18, 2009 4:45 PM

All replies

  • Where are your packages stored?

    You could probably use the SSIS API to traverse through them, or you can parse the XML of the .dtsx file.  Either way, I don't know of an easy out-of-the box method to do this.

    Phil Brammer | http://www.ssistalk.com
    • Marked as answer by Sonic.Jessy Sunday, September 27, 2009 1:40 AM
    Friday, September 18, 2009 4:45 PM
  • There is a commercial documentation tool as well that may help - BI Documenter - http://www.bidocumenter.com/Public/Default.aspx
    Phil Brammer | http://www.ssistalk.com
    Friday, September 18, 2009 4:47 PM
  • A crude way of doing this could be by parsing the .dtsx file as an XML stream and use of XPATHs.
    Hope this helps !!
    Please close the thread once answered

    Sudeep      My Blog
    Friday, September 18, 2009 5:52 PM
  • There's a good code sample for doing this here: http://sqlis.com/post/Exploring-packages-in-code.aspx
    John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com
    Friday, September 18, 2009 6:16 PM