SQL Server - Programmatically adding a SSIS component to the toolbox

Asked By j.mulder

06-Sep-07 10:54 AM

I am trying to create an installation package for a BI solution which
uses custom SSIS components. I would like to add the custom SSIS
components to the "Data Flow Transformations" tab page of the toolbox
of the Business Intelligence Development Studio from the installer. I
have tried to accomplish this with the following piece of code:

public void AddToolboxItem(string toolboxTabName, string
toolBoxItemName, string toolBoxItemPath)
{
Type dteReference;
EnvDTE.ToolBox toolBox;
EnvDTE80.ToolBoxItem2 addedToolBoxItem;

// Get a reference to the visual studio development
environment.
dteReference = Type.GetTypeFromProgID("VisualStudio.DTE.
8.0");

if(dteReference != null)
{
// Get a reference to the toolbox of the development
environment.
EnvDTE80.DTE2 dte =
(EnvDTE80.DTE2)Activator.CreateInstance(dteReference);
toolBox =
(EnvDTE.ToolBox)dte.Windows.Item("{B1E99781-AB81-11D0-
B683-00AA00A3EE26}").Object;

// Loop through all tab pages to find the toolbox tab
page that was specified
// in the toolboxTabName parameter.
foreach (EnvDTE80.ToolBoxTab2 toolBoxTab in
toolBox.ToolBoxTabs)
{
if(toolBoxTab.Name.ToLower() ==
toolboxTabName.ToLower())
{
// The specified toolbox tab page was found.

// First check if the
// component is not already in the toolbox.
foreach(EnvDTE80.ToolBoxItem2 toolBoxItem in
toolBoxTab.ToolBoxItems)
{
if (toolBoxItem.Name == toolBoxItemName)
{
string name = toolBoxItem.Name;
string objectText =
toolBoxItem.ToString();
return;
}
}

// The toolbox item is not in the toolbox tab
page. Now we can add it.
addedToolBoxItem =
(EnvDTE80.ToolBoxItem2)toolBoxTab.ToolBoxItems.Add(toolBoxItemName,
toolBoxItemPath,
EnvDTE.vsToolBoxItemFormat.vsToolBoxItemFormatDotNETComponent);

return;
}
}
}

}

I can get a reference to the "Data Flow Transformations" ToolBoxTab,
but adding an item to it fails without generating an error.

Is there any way to programmatically add a SSIS component to the
toolbox?

Kind regards,

Joost Mulders

06-Sep-07 11:42 AM

The more compact version of the cody I am trying to use:

Type dteReference;
EnvDTE.ToolBox toolBox;
EnvDTE80.ToolBoxItem2 addedToolBoxItem;

dteReference = Type.GetTypeFromProgID("VisualStudio.DTE.8.0");
if(dteReference != null)
{
EnvDTE80.DTE2 dte =
(EnvDTE80.DTE2)Activator.CreateInstance(dteReference);
toolBox = (EnvDTE.ToolBox)dte.Windows.Item("{B1E99781-AB81-11D0-
B683-00AA00A3EE26}").Object;

foreach (EnvDTE80.ToolBoxTab2 toolBoxTab in toolBox.ToolBoxTabs)
{
if(toolBoxTab.Name.ToLower() == "data flow transformations")
{
foreach(EnvDTE80.ToolBoxItem2 toolBoxItem in
toolBoxTab.ToolBoxItems)
{
if
(toolBoxItem.Name ==
return;
}

addedToolBoxItem =
(EnvDTE80.ToolBoxItem2)toolBoxTab.ToolBoxItems.Add(FlowSync,

@"C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents
\FlowSync.dll",

EnvDTE.vsToolBoxItemFormat.vsToolBoxItemFormatDotNETComponent);


return;
}
}
}