I don't see PowerPack components in SSIS Toolbox – ZappySys Help Center

There can be several reasons why you don't see ZappySys PowerPack components in SSIS Toolbox:

There were installation issues or you used 32-bit installer rather than 64bit (Re-Install needed).
Correct TargetServerVersion not set (For Visual Studio 2015+)
You did not expand Common section in the toolbox or you didn't look under Data Flow Tab
For older SSIS version (i.e. 2005 / 2008) you didn't add components manually in the toolbox.

SOLUTIONS

1. The best approach is that Uninstall the current Zappysys SSIS PowerPack using Control Panel (Go to control panel -> Add Remove programs -> Uninstall SSIS PowerPack) and Re-install it using the Typical(Default) settings and check the components in the Visual Studio. If still issue is there you can proceed below Troubleshooting.

2. Before Moving to the below solutions let's quickly search for installed dlls. Check for a specific directory based on your Target SQL Server version. For example search for ZappySys*.dll in \Program Files (x86)\Microsoft SQL Server\140\DTS\... folder. These files are used for SQL 2017 - SSIS toolbox / designer items.

NOTE: Screenshot may not show all possible version dlls but depending on your system installation you might see more or less version dlls.

File to check for SSIS/SQL Server 2022
{drive:}\Program Files (x86)\Microsoft SQL Server\160\DTS\Tasks\ZappySys.PowerPack160.dll

File to check for SSIS/SQL Server 2019
{drive:}\Program Files (x86)\Microsoft SQL Server\150\DTS\Tasks\ZappySys.PowerPack150.dll

File to check for SSIS/SQL Server 2017
{drive:}\Program Files (x86)\Microsoft SQL Server\140\DTS\Tasks\ZappySys.PowerPack140.dll

File to check for SSIS/SQL Server 2016
{drive:}\Program Files (x86)\Microsoft SQL Server\130\DTS\Tasks\ZappySys.PowerPack130.dll

File to check for SSIS/SQL Server 2014
{drive:}\Program Files (x86)\Microsoft SQL Server\120\DTS\Tasks\ZappySys.PowerPack120.dll

If files not found in correct directory means your installation is corrupted and you may have to re-install.

Option-1 : Make sure the common section is expanded in the SSIS toolbox

Some customers didn't see our components because common section in toolbar was not expanded.

Option-2 : Check Data Flow components

Some customers were not able to locate Data Flow specific items (e.g. JSON Source) because they were on the Control Flow tab. To see Source / Target / Transforms components you must look under under Data Flow Tab. It will refresh SSIS Toolbox when you go on Data Flow.

Option-3 : Reinstall the Latest ZappySys PowerPack

Now let's re-install SSIS PowerPack with correct settings. Few things to make sure Use 64-Bit Installer for 64bit OS. During Install Process choose custom option and make sure your desired version is selected (32 bit must be selected for toolbox items, 64 bit must be selected for SSIS Server Runtime / dtexec command line execution). In most cases you wont have to change any default settings. In rare case you may have to change it manually if we don't auto detect correctly.

NOTE: We added support for SSIS 2022 in version v5.1 and later so please check your version number if you want support for SSIS 2022.

Option-4 : Correct TargetServerVersion is set (For VS 2015+)

Sometimes changing TargetServerVersion may show up toolbox, so let's try to change it to lower version see it refresh your SSIS Toolbox.

Launch Visual Studio (VS 2015 or higher)
Create or Open your existing SSIS Solution.
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).
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

Option-5 : Choose Custom Setup - Add 64Bit Runtime - (Only For VS2022)

If you using SSIS designer in Visual Studio 2022 then there is a known issue in Runtime detection because VS2022 is 64 bit (compared to all previous VS versions which are 32-bit). To show ZappySys in VS2022 toolbox you must choose Custom Installation and Select 64Bit and 32Bit both Manually.

1. Run SSIS PowerPack Setup - When Prompted Ignore the warning about no SSIS Runtime / Designer Detected

2. Choose Custom Setup

3. Manually Enable 64bit / 32bit Runtimes (Features) as below

Option-6 : Add Items Manually (For SQL Server 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

Install SSIS PowerPack.
Launch Business Intelligence Development Studio (known as BIDS) From start menu under Microsoft SQL Server 2008/2005 folder.
Open or create new Integration Services Project (File | New | Project ... select Business Intelligence | Integration Services Project)
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)
Once Choose Items dialog box is loaded ... Click on [SSIS Control Flow Items] tab. Click on Name Column header to sort by Name. Check all items starting with BW.
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).
Click OK to close the dialog box.
After you close Choose Item dialog box your SSIS Toolbox should refresh and selected tasks and transform should appear under the respective category in the toolbox. Dataflow items will only appear if you switch to Dataflow designer.