Hi! I'm working with script component in SSIS. We defined many outputs to many tables with many columns :) Now we must change almost all datatypes of columns on db, and then in the process. Its very time-consuming and just annoying, boring activity to manually change, click by click, every datatype and column lenght in script output. It there ANY way to make this process quicker? Any kind of auto adjusting outputs that base on db, or any kind of text processing?
You should at using Biml (Business Intelligence Markup Language) to build your SSIS packages. You can utilize BimlScript (part of Biml) that will allow you to pull in the metadata of your database and auto-build the column definitions for a given task. If the component or task exist in SSDT-BI you can manipulate it in Biml. There is a [Stairway Series on Biml] from SSC site that can give you an overview. As well, [Cathrine Wilhelmsen has some great content] on the topic as well. :