Skip to content

Benny Austin

  • Home
  • About Me

Categories

Follow Benny Austin on WordPress.com

ErrorColumn name

COMExceptionComponentMetaDatadataflowdataflow column metadatadataflow discovererdataflow metadatadfldDtsComExceptionDtsExceptionDtsPipelineExceptionDtsTaskExceptionError OutputErrorCodeErrorColumnErrorColumn nameForEachLoopForLoopInputCollectionIntegration ServiceIntegration ServicesLineageIDMainPipeOutputCollectionPackageIDSequence ContainerSSIStaskhosttaskhost.InnerObject

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

Dataflow Discoverer (DFLD) is a command-line discovery utility that detects and writes the metadata of SSIS dataflow columns to a SQL Server lookup table. DFLD detects Dataflows nested within containers up to any level of nesting. For information on how to install and use DFLD utility,visit http://dfld.codeplex.com

DFLD works on one package at a time. It’s a typical ops requirement to keep the DFLMetadata of all SSIS packages up to date. This can be automated by creating a SSIS package similar to the one shown below Continue Reading

-33.867139 151.207114

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to print (Opens in new window)
  • Click to email a link to a friend (Opens in new window)
  • Click to share on Tumblr (Opens in new window)

Like this:

Like Loading...
7 Comments February 5, 2011October 5, 2012 Benny Austin
COMExceptionComponentMetaDatadataflowdataflow column metadatadataflow discovererdataflow metadatadfldDtsComExceptionDtsExceptionDtsPipelineExceptionDtsTaskExceptionError OutputErrorCodeErrorColumnErrorColumn nameForEachLoopForLoopInputCollectionMainPipeOutputCollectionPackageIDSequence ContainerSSIStaskhosttaskhost.InnerObject

SSIS: How to get name of ErrorColumn from Error Output?

SSIS automatically creates two columns on the Error Output from dataflow components – ErrorColumn and ErrorCode. ErrorColumn contains the column ID of the erroneous column. Column ID is a number that is unique to a dataflow within the package. Similarly ErrorCode contains the error number that caused the row to be rejected. At the moment, SSIS by default does not provide ErrorColumn name and ErrorCode description. These can be derived using the methods described below. Continue Reading

-33.867139 151.207114

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to print (Opens in new window)
  • Click to email a link to a friend (Opens in new window)
  • Click to share on Tumblr (Opens in new window)

Like this:

Like Loading...
20 Comments February 4, 2011August 13, 2014 Benny Austin
Blog at WordPress.com.
  • Follow Following
    • Benny Austin
    • Join 66 other followers
    • Already have a WordPress.com account? Log in now.
    • Benny Austin
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
%d bloggers like this: