Help >
Getting Started - Using SSIS PowerPack
PreviousNext

License Note: By default you will get 30-days fully functional trial (No License key needed for Trial). If you already purchased software then you must download SSIS PowerPack installation file from Customer Download Area (Click here). You cannot activate purchased license key if you downloaded Trial build from public site. To apply license key you must download FULL version.

In this section you will learn how to access SSIS PowerPack functionality after installation.

Troubleshooting - Toolbox Items not visible after installation?

Check the steps described in the next sections to see installed ZappySys components in the SSIS designer. For some reason if you don't see ZappySys components in the toolbox then check below link. What should I do if I don't see ZappySys Tasks in Visual Studio Toolbox.

How to find installed SSIS Tasks/Components?

After installation, new ZappySys SSIS tasks/components will appear under following two SSIS toolbox (i.e.e Control Flow and Data Flow). Make sure you go under both toolbox and verify new components.
  1. Open Visual Studio (i.e. SSDT or SQL Server Data Tools)
  2. Open existing SSIS Project or Create new by clicking on Project > Business Intelligence > Integration Services Project
  3. Once SSIS Package Designer is open, Click on the Control Flow Tab to see SSIS Toolbox. If toolbox is hidden then right click in the blank designer surface area and click SSIS Toolbox menu item.
  4. Check SSIS Toolbox. Any items starting with ZS are ZappySys Tasks.
  5. Do the same thing to find Data Flow Components.
  6. Click on Data Flow Tab and you will see SSIS Toolbox will refresh. Any items starting with ZS are ZappySys Components
ssis-toolbox-where-is-control-flow-task-data-flow-components.png

Content

For SQL Server 2017 (vNext) - SSDT BI for Visual Studio 2015/2017 (Apr 2017 Update or later)

If you have downloaded SSDT BI for Visual Studio 2015 or 2017 after April 2017 and you notice that ZappySys Tasks not showing up in the SSIS Toolbox then read this section. New version of SSDT BI comes with support of SQL Server vNext (2017). You may not realize but in the latest SSDT for VS 2015 by default when you create SSIS Package it will target vNext (SQL Server 2017). If vNext is selected as Target version then you will not see any ZappySys Tasks/Components in SSIS Toolbox. To switch to lower SSIS version (i.e. SSIS 2016, 2014 or 2012) perform the following steps so you can see ZappySys Components in the SSIS toolbox.
Note: Starting from Visual Studio 2015, Microsoft introduced authoring SSIS Packages for multiple versions (i.e. Same Visual Studio version can be used to edit packages for 2012, 2014, 2016, vNext). Also you can Upgrade or Downgrade SSIS package format in few clicks (see below steps)
  1. Install SSIS PowerPack.
  2. Launch Visual Studio 2015 or 2017. Create or Open your existing SSIS Solution.
  3. In the solution explorer, Right click on the SSIS Project Node and click Properties (This node may be one level below solution node as below screenshot).
  4. When you see Properties select Configuration Properties. You will see TargetServerVersion change that to other than vNext and click Yes if you see warning of Downgrade and then Click OK.
    ssdt-sql-server-data-tools

For SQL Server 2012, 2014, 2016

For SQL Server 2012 or higher you don't have to do any additional work to find your newly installed components. In SSIS 2012 newly installed components automatically appears in the SSIS Toolbox. Please perform the following steps to find SSIS PowerPack Tasks and Components
  1. Install SSIS PowerPack.
  2. Launch SQL Server 2012 Data Tools or SSDT (Previous known as BIDS) From start menu under Microsoft SQL Server 2012 folder.
    ssdt-sql-server-data-tools
  3. Open or create new Integration Services Project (File | New | Project ... select Business Intelligence | Integration Services Project
  4. Once SSIS Project is loaded look under SSIS Toolbox.... You will find all PowerPack tasks starting with BW
    ssis-toolbox-sql-2012
  5. To find Source, Targets and Adapters you have to switch to DataFlow Tab and look under SSIS Toolbox.... You will find all PowerPack Sources, Targets, Transforms starting with BW
    ssis-toolbox-sql-2012-dataflow

For SQL Server 2008 R2, 2008, 2005

For SQL Server 2008 R2 or prior version there is no automatic toolbox refresh for SSIS. So you will have to Add new Tasks/Components manually by performing following steps
  1. Install SSIS PowerPack.
  2. Launch Business Intelligence Development Studio (known as BIDS) From start menu under Microsoft SQL Server 2008/2005 folder.
    bids-sql-server-business-intelligence-development-studio
  3. Open or create new Integration Services Project (File | New | Project ... select Business Intelligence | Integration Services Project)
  4. Once SSIS Project is loaded right click under SSIS Toolbox ... Click [Choose Items]... Wait for few seconds (sometimes loading Items dialog box takes very long)
    ssis-toolbox-sql-2008-2005-choose-items-add-tasks
  5. Once Choose Items dialogbox is loaded ... Click on [SSIS Control Flow Items] tab. Click on Name Column header to sort by Name. Check all items starting with BW.
    ssis-toolbox-sql-2008-2005-choose-items-add-tasks
  6. After you select Task now click on [SSIS Data Flow Items] tab. Click on Name Column header to sort by Name. Check all items starting with ZS (ZappySys).
    ssis-toolbox-sql-2008-2005-choose-dataflow-items-add-transforms-source-target-adpaters
  7. Click OK to close dialogbox.
  8. After you close Choose Item dialogbox your SSIS Toolbox should refresh and selected tasks and transform should appear under respective category in toolbox. Dataflow items will only appear if you switch to Dataflow designer.
    ssis-toolbox-sql-2008-2005-choose-dataflow-items-add-transforms-source-target-adpaters

FAQ

References


Copyrights reserved. ZappySys LLC.