SSIS Custom task - drop down list in the UI window

Hi,

    I'm writing my first SSIS custom task. I have added Public properties, which appear in the standard task properties window, and to one of them I have added an EditorAttribute as follows:

    <Category("General"), _
    Browsable(True), _
    EditorAttribute(GetType(UIFileNameEditor), _
    GetType(System.Drawing.Design.UITypeEditor))> _
    Public Property FilesToArchive() As String
        Get
            Return Me.m_FilesToArchive
        End Get
        Set(value As String)
            Me.m_FilesToArchive = value
            If m_FilesToArchive.Length > 0 Then
                m_FolderToArchive = String.Empty
            End If
        End Set
    End Property

When I select the FilesToArchive property in the Properties window, I get an ellipsis that appears in the property value. When I click on the ellipsis, it brings up the FolderBrowserDialog, which is defined in the UIFileNameEditor class. This all works fine.

What I want to do is to bring up the EditorUI, the one you get when you double click on the task, and also populate that with properties which can be edited. I have a class which inherits DTSBaseTaskUI, which is displayed when I double click on the task.

I can also get properties to be displayed in that UI but I cannot get them to be editable in that UI, using the same technique as in the standard Properties window, as described above.

Can anyone help please?

Thanks,

Kevin

 

May 23rd, 2015 12:55pm

Hi Kevin,

According to your description, you want to add some code for EditorUI window of the custom task, the one you get when you double click on the task, and also populate that with some properties which can be edited.

Based on my research, there are some good blogs explain how to develop the EditorUI window for custom tasks. For more details, please see:
http://microsoft-ssis.blogspot.com/2013/06/create-your-own-custom-task.html
http://sqlblog.com/blogs/andy_leonard/archive/2013/01/04/creating-a-custom-ssis-2012-task-series.aspx

Thanks,
Katherine Xiong

Free Windows Admin Tool Kit Click here and download it now
May 25th, 2015 3:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics