Building Custom Tasks for SQL Server Integration Services

Index

A, B

1. Base class, Object Browser

   1. open

   2. task class

2. Build Action property

C

1. Class

   1. base

   2. decorating

   3. inheriting task

   4. private variable

   5. property

2. Click event

   1. add form constructor

   2. of btnDone

   3. building

   4. code

   5. form class

D

1. Data Integration Lifecycle Management (DILM)

2. Delete method

3. Demo code

4. DialogResult property

5. DTSTask attribute

E

1. Execute method

   1. task functionality

   2. troubleshoot

      1. attach to process

      2. breakpoint properly configured

      3. continuing after hit breakpoint

      4. correct process

      5. edit SSIS breakpoint

      6. hit breakpoint

      7. Locals window

      8. OnPreExecute event breakpoint

      9. set breakpoint

F

1. Form

   1. add

   2. add done button

   3. add label and text box

   4. coding click event and

   5. constructor

   6. controls

   7. DialogResult property

G, H

1. GetView method

2. Global Assembly Cache (GAC)

I, J

1. Icon file

   1. add existing item

   2. Build Action property

   3. DtsTask decoration

   4. form