Click to Rate and Give Feedback
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
IDtsComponentUI Interface

Defines the methods called by SSIS Designer for the user interface of a data flow component. This interface is not CLS-compliant.

Namespace: Microsoft.SqlServer.Dts.Pipeline.Design
Assembly: Microsoft.SqlServer.Dts.Design (in microsoft.sqlserver.dts.design.dll)
VisualBasicDeclaration
<CLSCompliantAttribute(False)> _
Public Interface IDtsComponentUI
CSharp
[CLSCompliantAttribute(false)] 
public interface IDtsComponentUI
ManagedCPlusPlus
[CLSCompliantAttribute(false)] 
public interface class IDtsComponentUI
JSharp
/** @attribute CLSCompliantAttribute(false) */ 
public interface IDtsComponentUI
JScript
CLSCompliantAttribute(false) 
public interface IDtsComponentUI

Component developers can provide a user interface for a data flow component by specifying a Type and implementing this interface in the UITypeName property of the DtsPipelineComponentAttribute attribute. The designer calls the methods of this interface when the component is added, deleted, and edited inside the SSIS Designer.


The following code sample demonstrates a class that implements the IdtsComponentUI interface. For more information and the complete sample, see Developing a User Interface for a Data Flow Component.

CSharp
using System;
using System.Windows.Forms;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Pipeline.Design;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;

namespace Microsoft.Samples.SqlServer.Dts
{
    public class SampleComponentUI : IDtsComponentUI
    {
        IDTSComponentMetaData100 md;
        IServiceProvider sp;

        public void Help(System.Windows.Forms.IWin32Window parentWindow)
        {
        }
        public void New(System.Windows.Forms.IWin32Window parentWindow)
        {
        }
        public void Delete(System.Windows.Forms.IWin32Window parentWindow)
        {
        }
        public bool Edit(System.Windows.Forms.IWin32Window parentWindow, Variables vars, Connections cons)
        {
            // Create the component's form, and then display it.
            SampleComponentUIForm componentEditor = new SampleComponentUIForm(cons, vars, md);

            DialogResult result  = componentEditor.ShowDialog(parentWindow);

            if (result == DialogResult.OK)
                return true;

            return false;
        }
        public void Initialize(IDTSComponentMetaData100 dtsComponentMetadata, IServiceProvider serviceProvider)
        {
            // Store the component metadata.
            this.md = dtsComponentMetadata;
        }
    }
}
VisualBasic
Imports System 
Imports System.Windows.Forms 
Imports Microsoft.SqlServer.Dts.Runtime 
Imports Microsoft.SqlServer.Dts.Pipeline.Design 
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper 

Public Class SampleComponentUI 
Implements IDtsComponentUI 
 Private md As IDTSComponentMetaData100 
 Private sp As IServiceProvider 

 Public Sub Help(ByVal parentWindow As System.Windows.Forms.IWin32Window) 
 End Sub 

 Public Sub New(ByVal parentWindow As System.Windows.Forms.IWin32Window) 
 End Sub 

 Public Sub Delete(ByVal parentWindow As System.Windows.Forms.IWin32Window) 
 End Sub 

 Public Function Edit(ByVal parentWindow As System.Windows.Forms.IWin32Window, ByVal vars As Variables, ByVal cons As Connections) As Boolean 
   Dim componentEditor As SampleComponentUIForm = New SampleComponentUIForm(cons, vars, md) 
   Dim result As DialogResult = componentEditor.ShowDialog(parentWindow) 
   If result = DialogResult.OK Then 
     Return True 
   End If 
   Return False 
 End Function 

 Public Sub Initialize(ByVal dtsComponentMetadata As IDTSComponentMetaData100, ByVal serviceProvider As IServiceProvider) 
   Me.md = dtsComponentMetadata 
 End Sub 
End Class

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker