Script Components in SSIS dataflows are very powerful, but also usually not easy to maintain. The main reason being that all columns inside the script are accessed by their names and any attempt to reuse a script means that it has to be rewritten almost every time.
If the columns of a Script Components can be accessed by their position in their stream, some code could be easily reused as it would be easily possible to iterate over these columns.
The basic concept to do that will be demonstrated for some examples
– to clean and report data for outliers at runtime
– map output columns to input columns at runtime, depending on input data
– write Parquet-Files and load the data directly to a SNOWFLAKE database
Sign up to stay up to date with news, special announcements and educational content.
Redgate will only contact you about PASS Data Community Summit (in line with our Privacy Policy) unless you separately request emails about Redgate. You can unsubscribe from these updates at any time.
Summit video library