O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

  1. Open the SSISCustomization.sln solution that you created in the Designing a custom transformation recipe, earlier in this chapter.
  2. In the SSISCustomComponents project, locate the ValidateEmail.cs file, and open it in the designer.
  3. Modify the DtsPipelineComponent attribute of the ValidateEmail class, and add the CurrentVersion property, as shown in the following example:
[DtsPipelineComponent 
    ( 
    ComponentType = ComponentType.Transform, 
    DisplayName = "Validate Email", 
    Description = "Validates email addresses using the corresponding rule in a data profile file.", 
    NoEditor = false, 
    CurrentVersion = 2 
    )] 

Do not forget the comma after the NoEditor property declaration! When the CurrentVersion property is set, SSDT at design time ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required