How do I generate the input /output columns dynamically in SSIS script component (transformation) using BIML

617 Views Asked by At

How do I dynamically generate script component(transformation) input and output columns using BIML?

I have created microsoft-ssis.blogspot.com's 2015-02 sample

The problem with that approach is the input and output columns for script component are hard coded.

I have 1000 files. For each file, the input and output columns in the component vary.Can anybody help me on that?

Thanks in advance

Anil

0

There are 0 best solutions below