You can accomplish a lot with standard transformations, but sometimes the Script Component provides an easier solution. For example, a nested if construction is very possible in a derived column, but it becomes unreadable and unmaintainable if you have a lot of levels or conditions. And some features are just not available in the out-of-the-box components. This chapter shows some of the situations where a Script Component is useful.
Data Flow Symmetric Encryption Data Viewer Connection Manager Asymmetric Encryption
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
This is a preview of subscription content, log in to check access.