Frequently Asked Questions (FAQ)

How do I get Task Factory components to show up inside of the BIDS or Visual Studio Toolbox?

If you are running SQL Server 2005 or 2008, Task Factory components do not automatically appear within the BIDS or Visual Studio Toolbox. To get Task Factory components to appear, follow these steps:

  1. Open up an SSIS Packages within BIDS or Visual Studio
  2. Open up your toolbox (If it is not already viewable, click View > Toolbox)
  3. Right click inside of the toolbox window and select “Choose Items…” Important Note: It may take a couple of minutes for the “Choose Toolbox Items” dialog box to appear.
  4. Once the “Choose Toolbox Items” dialog box appears, select the “SSIS Control Flow Items” tab.
  5. Click on the “Type Name” column to sort the components. Select all (or any unchecked) components starting with PW.TaskFactory.
  6. Select the “SSIS Data Flow Items” tab.
  7. Click on the “Type Name” column to sort the components. Select all (or any unchecked) components starting with PW.TaskFactory.
  8. Press OK.

Important Note: If you are running Task Factory using SQL Server Data Tools (2012) then all Task Factory Components should automatically appear inside of the SSIS Toolbox. If you do not see the components there are typically two reasons for this. The first is you may not have downloaded Task Factory with 2012 support,this is the most common cause for missing TF components (please see screen shot below). The other possibility is you may be searching the ‘Toolbox’ in SQL 2012 and not the ‘SSIS Toolbox’. This happens a lot with people who are new to SQL2012. Please be sure you are looking at your ‘SSIS Toolbox’ and not the standard ‘Toolbox’ by right-clicking in the design window and then selecting ‘SSIS Toolbox’.

Some of our clients