When writing a custom SSIS task the best practice is to create the UI separate from the control. This will allow the task to run faster during package execution. One of the problems people have when creating a custom SSIS task is, knowing the fully qualified namespace of the task to enter into the UITypeName. Example:Namespace SendMailAdvancedNS
<DtsTask(DisplayName:="Send Mail Advanced", _
IconResource:="SendMailAdvancedNS.Letter.ico", _
Description:="Send Mail with Advanced Features", _
UITypeName:="SendMailAdvancedNS.SendMailAdvancedNS.SendMailAdvancedUI,SendMailAdvancedUI, Version=1.0.0.0, Culture=Neutral, PublicKeyToken=e69ec455025fad04", _
TaskContact:="Support PragmaticWorks.com (c) 2008 ;http://www.pragmaticworks.com")> _
Public NotInheritable Class SendMailAdvanced The UITypeName can be hard to know if you have little experience creating custom SSIS task. The easiest way to find it is to look in the list of task in business intelligence development studio after you have installed the dll to the GAC.1. Start Business Intelligence Development Studio(BIDS)
2. Open an existing Integrated Services Project or create a blank one
3. Right click on the tool box and select choose item...
4. Select the SSIS control flow Items Tab
5. Scroll down to find the DLL you installed in the GAC, the fully qualified Namespace will be listed in the "Type Name" columnIn the case above it was SendMailAdvancedNS.SendMailAdvancedNS.SendMailAdvanced,
I was then able to set the UITypeName to SendMailAdvancedNS.SendMailAdvancedNS.SendMailAdvancedUI
About Mike Davis
Mike Davis, is a developer, consultant, trainer, and mentor who is enthusiastic about developing robust application for SQL server. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Database Administration, and .Net Software Development. Mike has created BI and software solutions for financial institutions and pragmatic works. He has developed .Net applications for SQL add-ons as well as standalone applications. Mike also participates as a speaker at events like SQL Server 2008 launch and SQL server user group meetings .
How Big Is Your Package?