question

lukjak avatar image
lukjak asked

[SSIS] Script component auto outputs?

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?
ssisoutputscript-task
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Shawn_Melton avatar image
Shawn_Melton answered
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][1] from SSC site that can give you an overview. As well, [Cathrine Wilhelmsen has some great content][2] on the topic as well. [1]: http://www.sqlservercentral.com/stairway/100550/ [2]: http://www.cathrinewilhelmsen.net/biml/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.