7 thoughts on “DFLD: How to capture/refresh Dataflow column metadata from multiple packages using Dataflow Discoverer?

  1. I can’t get it to work

    08:45:18 INFO: DFL Discovery Started…
    08:45:18 The package failed to load due to error 0xC0011008 “Error loading from
    XML. No further detailed error information can be specified for this problem bec
    ause no Events object was passed where detailed error information can be stored.
    “. This occurs when CPackage::LoadFromXML fails.

  2. Hi there,
    This is briliant post as I have developed this today
    I have a quick Question that I want to call the packages from Integration services instead from file system…is that possible ?
    I mean like this

    dfld /p:server\packagepath.dtsx /s:wdc-Sitsql002\datasource /d:ETLmetadata

    as I don’t want to call them from file system.

    Please let me know if you have any solution

    1. Sai, thanks for your feedback. DFLD was written prior to SQL Server 2012 when msdb deployment was not common. So DFLD is file based at the moment. Future versions of DFLD could incorporate this feature. In the meanwhile if you come up with a workaround, pls feel free to post here.

  3. Great tool. It gets me close to populating a source to target Metadata tool. Having a bit of difficulties with mapping input and destination columns? Trying to figure out what ID maps the two in the package file. Or is it just their order in the package file? Let me know if you have any suggestions.

    1. hi Joel, Thanks for your comments. The information about input to output mapping is specific to type of Dataflow component and is available as Custom Properties of that component. For e.g Derived Column component has information about the formula that makes up the new column and Pivot component has information about the source column and the pivot key. At the moment DFLD captures Common and Data Type properties. I am considering enhancing DFLD to include Custom properties as well. I’ll keep you posted. Meanwhile the UpstreamComponentName might be of some help to trace where the column originated from.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s