Post reply

How to access properties which aren't on the properties dialog (data flow component specifically)

  • December 11, 2008 at 11:04 am

    #124944

    Hi - probably a very silly question, but how do i access some properties/collections which aren't in the properties dialog of a particular task? For example, I would like to pass as parameters columns mappings for a table (Destination Data Flow component), not do it through the graphics. For the migration excercise i would like to have 1 source data flow component and 1 destination data flow component and i pass in from a parent package the tablename, mappings, conversions etc. Surely this is a decent way of doing the migration? Or is this overkill? Anyway - getting back to the point, I can't see any of the required properties - e.g. available input cols, available dest cols etc. Or are they not properties?! Thanks in advance...! Cheers, Jon

  • December 12, 2008 at 10:24 am

    #911781

    I'm not sure where you are looking for the needed information, but you have to concentrate on PipelineComponent API and ComponentMetaData property in particular. This is where you will find the inputs, outputs etc.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply