Upgrading a Custom Data Flow Component
When you determine that a custom component that might have already been deployed to production use needs to be modified – for instance, to implement a bug fix, to add an improvement, or simply to extend its capabilities – you can take advantage of a built-in feature of the PipelineComponent class to automate the upgrade.
Tip
In general, all the changes needed by the upgrade should be delivered without the need for user intervention – for instance, if the new version uses properties that were not available in the previous version(s), then default values should be provided as well.
After the new version of the component has been deployed to the target environment, the upgrade is performed automatically:
- At design time when the package that implements the component is opened in SSDT
- At runtime when the package that implements the component is executed
Important note
If the upgrade cannot be completed successfully...