Script Component Plus Dynamic Columns

[Jason Adams]

Is it possible to use the Script Component Plus as a Source with defining the output columns through the script?  If so, is there an example online anywhere?

Jason 

[Ivan Peev]

Hi Jason,

Yes, it possible. However you have to use COZYROC Data Flow Task Plus, which provides functionality for processing dynamic data flows.

[Jason Adams]

Unfortunately that doesn't really answer the question.  I am talking about using the Script Component Plus within the Data Flow Task Plus.  Then within the script component dynamically add columns to the output buffer.

[Ivan Peev]

Jay,

Please provide more details why do you want to have script which setups dynamic output columns. Yes, it is possible. There is just no sample available. You setup your output columns in the ReinitializeMetaData method override.

[Jason Adams]

First off I will say CozyRoc is the best set of components I have ever encountered.  For the most part our ETL developers spend no time doing work in SSIS itself anymore as we are 98% configuration based etl.  We have 1 primary SSIS package that handles all of processes and we have a lot, we then do have some child packages for handling special dynamic data flows that are also very configurable.  The one I am going to be working on next is to create a script component that will get configurable information from a configuration database about how to process XML files.  This will include xpath/xquery statements and output columns.

I am doing it this way instead of the using the XML Source component that comes with SSIS since even in a dynamic data flow, the XML source cannot have the schema change.  Plus I never liked the XML source, and have always used script components for reading XML, it provides a lot more functionality over the XML Source.

I will take a look at ReinitializeMetaData method.  This sounds like what I was missing.