Installation and Getting Started

Installation and Getting Started

Overview

This article contains information to help ensure proper installation and configuration of your environment, but most importantly, ensure that COZYROC SSIS+ Suite will work with the installed components (e.g., SQL Server, SSDT).  Although SSDT is downward compatible, not every SQL Server version is supported.  In order to avoid compatibility issues, install the COZYROC SSIS+ Suite recommended for the SSDT version.

The compatibility chart below will guide you in determining, which component version is compatible with the COZYROC SSIS+ Suite . We strongly recommend that you install the compatible versions of the software noted in the chart before you install the COZYROC SSIS+ Suite. The chart includes links to versions of SSDT to make it easy to download and install a compatible version for the version of SQL Server and SSIS+ you will be running.

In most cases, your best bet will be to use the latest version of the COZYROC SSIS+ Suite. It is backwards-compatible with all versions of SQL Server. 

It is important to be aware that, even if you install a compatible version of Visual Studio, automatic updates could install an incompatible version of Visual Studio in the future. Therefore, we highly recommend that you turn off automatic updates for all software that can create compatibility issues.

It is also mandatory that you install the COZYROC SSIS+ Suite on any machines where you plan to develop, execute, and/or schedule the execution of SSIS packages that contain COZYROC SSIS+ components.  We also recommend that you only install one version of SSDT on the server where you design or run packages.

NOTE: when you use COZYROC SSIS+ components in your SSIS packages, no sensitive information will ever be sent to COZYROC for any reason. In SSIS+ 1.9, we have introduced a telemetry module to collect information about product usage that will assist us in making product improvements. During installation, you are asked whether you would like to allow us to collect this information or not. We will never collect this information without your permission. 

Compatibility Charts

Before installing the COZYROC SSIS+ Suite , please check below for its compatibility with SQL Server, Visual Studio and SSDT. Installing software that is compatible with the SSIS+ Suite before you begin will ensure a much smoother and more rewarding experience, free from unnecessary delays. 

Note that the SSIS+ Suite will need to be installed on any machines where you will be designing SSIS packages that use COZYROC SSIS+ components. It will also need to be installed on any Servers where you plan to schedule and execute SSIS packages that contain SSIS+ components.  

SQL and Visual Studio Compatibility    


COZYROC SSIS+
Supported versions of SQL Server
Supported versions of Visual Studio
2.0
2019, 2017, 2016, 2014, 2012
2019, 2017, 2015, 2013, 2012, 2010
1.9
2019, 2017, 2016, 2014, 2012, 2008, 2005
2019, 2017, 2015, 2013, 2012, 2010, 2008, 2005
1.8
2017, 2016, 2014, 2012, 2008, 2005
2017*, 2015, 2013, 2012, 2010, 2008, 2005
1.7
2016, 2014, 2012, 2008, 2005
2015**, 2013, 2012, 2010, 2008, 2005
1.6
2014, 2012, 2008, 2005
2013, 2012, 2010, 2008, 2005
1.5
2008, 2005
2008, 2005
1.4
2008, 2005
2008, 2005
1.3
2008, 2005
2008, 2005
SQL Server
Supported versions of Visual Studio
2019
2019, 2017
2017
2019, 2017, 2015
2016
2019, 2017, 2015
2014
2019, 2017, 2015, 2013, 2012
2012
2019, 2017, 2015, 2012, 2010
2008
2008
2005
2005

 

 

 

 

 

 

 

 

 

 





* SSIS+ 1.8 in Visual Studio 2017 is not supported in SSDT 15.8.1 or later (i.e. SSDT with SQL Server 2019 support)
** SSIS+ 1.7 in Visual Studio 2015 is not supported in SSDT 17.0 or later (i.e. SSDT with SQL Server 2017 support)

SSDT Downloads and Compatibility

The following table is provided to help ensure proper installation and configuration of your environment, but most importantly, ensure that COZYROC SSIS+ Suite will successfully work. Although SSDT is downward compatible, not every SQL Sever version is supported. In order to avoid compatibility issues, installed the COZYROC SSIS+ Suite recommended for the SSDT version.  



SSDT
Visual Studio
Download
Build Number
Release Date
SQL Server
COZYROC SSIS+
3.10  
2019
SSDT for VS2019 3.13.1
15.0.2000.132
09/23/2020
2012, 2014, 2016, 2017, 2019
1.9+ or (1.9 and above)
15.9.4
2017
SSDT for VS2017 15.9.4
14.0.16214.0
9/5/2018
2012, 2014, 2016, 2017, 2019
1.9+ or (1.9 and above)
15.8.0
2017
SSDT for VS2017 15.8.0
14.0.16174.0
9/5/2018
2012, 2014, 2016, 2017
1.8+ or (1.8 and above)
17.4.0
2015
SSDT for VS2015 17.4.0
14.0.61712.050
Unavailable
2012, 2014, 2016, 2017
1.8+ or (1.8 and above)
17.3.0
2015
SSDT for VS2015 17.3.0
14.0.61709.290
Unavailable
2012, 2014, 2016, 2017
1.8+ or (1.8 and above)
16.5.0
2015
SSDT for VS2015 16.5.0
14.0.61021.0
10/20/2016
2012, 2014, 2016
1.7+ or (1.7 and above)
16.5.0
2013
SSDT for VS2013 16.5.0
12.0.61021.0
10/26/2016
2014
1.6+ or (1.6 and above)

Note: Before installing   SSDT for Visual Studio 2017 (15.9.1) , uninstall Analysis Services Projects and Reporting Services Projects extensions if they are already installed, and close all VS instances. All release notes related to SSDT for SQL Server 2017 can be found at this link

For recommended SSDT versions for use with Data Flow Task Plus, please see the following link .  

Installation    

To get started, you will need to fill in and submit the Download form from the Download page. Afterward, you will be sent an email with a link to the page where you can access and/or download the COZYROC SSIS+ Suite.

Note: all versions of the SSIS+ Suite are backwards-compatible, so it is not necessary to run multiple versions of the COZYROC SSIS+ Suite on the same server and, in fact, it will not work.

There are special considerations if you want to run the COZYROC SSIS+ Suite on Azure Data Factory (ADF) .  Please review the article below for a description of what you will need to know to get the COZYROC SSIS+ Suite running on ADF.

Quick Start
  1. How to install the COZYROC SSIS+ Components Suite 

Knowledge Base Articles
  1. Where can I find the End User License Agreement (EULA)? 
  2. What are the recommended steps for installation? 
  3. Is it required to install SSDT on the SQL Server? 
  4. COZYROC recommended SSDT versions for Data Flow Task Plus 
  5. Can different versions of COZYROC's SSIS+ Suite co-exist on the same server?
  6. How to retrieve the license key via the License Application
  7. How to get my license key when my server sits behind a firewall and I'm unable to contact the COZYROC license server.
  8. How to license a server for SSIS Catalog deployment.
  9. How to install SSIS Plus from command line as a silent install.
  10. How to run COZYROC and SSIS on Azure Data Factory
  11. Why are there not any modules during the installation?
  12. Error Message: License: <NAME> component is not licensed. 

Post Installation

When you open the SSIS toolbox in Visual Studio, all the COZYROC components will show up in the toolbox.  It is no longer necessary to use “Choose Toolbox Items” as shown in some of COZYROC’s older videos because, as of the 2012 version of Visual Studio, there is no need to import the extensions to SSIS. When you run the COZYROC installer package file, the extensions are imported and automatically show up in the SSIS Toolbox.

If some or all of the COZYROC SSIS+ components are missing from the Toolbox, re-check the compatibility charts; it is highly likely that you have an incompatible version of SSDT or Visual Studio installed.

It is worth mentioning that users have encountered other errors due to improper COZYROC license activation.  Please see the Licensing page for a complete description of how to successfully activate your license.  It provides information about registry keys and permissions that must be set properly.

Note: if you are using SSIS Catalog deployment, you will need to deploy the license key for COZYROC SSIS+ Suite on the server where the catalog is stored to properly license the COZYROC SSIS+ Suite and execute your packages.

Starting in late 2018, you must manually select the  TargetServerVersion  to use for your packages in Visual Studio.  Be sure to set this for the version of SQL Server where you’ll be executing your packages. 

If you are going to be using a proxy account to execute your packages under the SQL Job Agent, then you should ensure that the proxy account has permissions to access certain folders and registry keys. See the KB articles below for specifics about the folder and registry keys.

Users sometimes have difficulties due to the settings of other server parameters that are unrelated to the COZYROC SSIS+ Suite.  For example, if you are using a COZYROC component that requires a password to connect to a service or a server and your Package Protection Level is set to " DontSaveSensitive ”, then the password will not be saved with the package and the package will fail to connect.  Please see the KB articles below for further information about these settings and how to get things working with the setting you choose.  


Knowledge Base Articles 
  1. Why do I not see the COZYROC components in the SSIS Toolbox in Visual Studio?
  2. How To Verify the Release Installed for Visual Studio, SSDT, SQL Server, and COZYROC SSIS+
  3. When executing an SSIS package from the command line, it works properly. However, when I run the same package from the SQL Job Agent, it fails.
  4. How to license a server for SSIS Catalog deployment
  5. How To change the permissions on the License file from inherited to explicit. 
  6. When I run an SSIS package under the SQL Job Agent with a proxy account, I get the error: Access Denied
  7. How do I start using COZYROC SSIS+ in Business Intelligence Development Studio (BIDS) or Visual Studio? 
  8. I am not seeing the COZYROC tasks and components in “Choose Toolbox Items” in Visual Studio.  
  9. How-To add a component to the SSIS Toolbox? 
  10. Error Message: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.
  11. Error Message: Couldn't get process information from performance counter.
  12. Error Message: Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error CS2008: No inputs specified.
  13. Why do I get the following error when executing a package under a SQL Server Agent job: "Failed to decrypt protected XML node "ServerPassword" with error 0x8009000B..."? 

Upgrading/Migration

Whenever you upgrade your version of the COZYROC SSIS+ Suite or SQL Server, check the compatibility charts before installing the new version.  It is also recommended that you install the compatible version of SSDT and Visual Studio before installing the new version of the COZYROC SSIS+ Suite.  Be sure to uninstall the old version prior to installing the newer version.

Note: if you are performing an upgrade on an existing server, there is no need to reset your license record.  However, if the versions of the existing installed components have changed (e.g., SQL Server), you will need to reset your License record.  You will find step-by-step instructions describing how to reset your License record on the Licensing page .

Likewise, whenever you migrate the COZYROC SSIS+ Suite to a different server, be sure to check the compatibility charts.  Install compatible versions of SSDT and Visual Studio before installing the SSIS+ Suite on the new server.

It is not necessary to edit, rebuild or redeploy packages created in the older version of SSIS+ unless you are upgrading from SSIS+ versions prior to 1.7 SR-2.

Note: an intermediate upgrade is required in order to upgrade from a version of the COZYROC SSIS+ Suite older than 1.7 SR-2 to a newer version. See the KB article below in this section.

As previously mentioned, it is not possible to run multiple versions of the COZYROC SSIS+ Suite on the same server, even during an upgrade.  If the COZYROC SSIS+ Suite had that capability, it would make upgrades more difficult because each package would have to be updated to indicate the version of the COZYROC SSIS+ Suite to use. Our recommendation is to thoroughly test your packages with the newer versions of the COZYROC SSIS+ Suite before upgrading your production environment.

All versions of the COZYROC SSIS+ Suite are backwards compatible, so it is not necessary to run multiple versions of SSIS+ on the same server and it will not work if you try to install multiple versions.

Knowledge Base Articles
  1. How to migrate your COZYROC SSIS+ license to a new server
  2. How To upgrade an existing COZYROC SSIS+ Suite installation to a higher version.
  3. How to upgrade from SSIS+ versions older than v1.7 SR-2 to SSIS+ versions 1.7 SR-2 or newer.
  4. Should I uninstall previous versions of the SSIS+ Suite before installing a different version? 
  5. Error Message: CozyRoc component not licensed
  6. Error Message: The task with the name “XXXX” and the creation name “SSIS.ReplacementTask” is not registered for use on this computer. 

Uninstall    

Uninstalling SSIS+ is easy. Using the Windows Start menu, there is an “Uninstall” option in the sub-menu of the COZYROC application folder.

Knowledge Base Articles
  1. How can I uninstall COZYROC's SSIS+?

Tools    

Troubleshooting problems related to communications with online services (e.g., services that use REST, SOAP or HTTPS web requests) requires the use of external tools.  We recommend the use of Fiddler for these types of problems.  Instructions explaining how to use Fiddler to trace exchanges between your SSIS packages and these services can be found in the KB article below.  It will also explain how to create trace files that can be provided to the COZYROC support team so that they can assist you with troubleshooting.

Knowledge Base Articles
  1. How to trace HTTP(S) and REST API using Fiddler. 

How to use the Help Center   

COZYROC support is evolving from using email for support to having a full-blown support center that includes Knowledge Base articles and a ticketing system for handling trouble tickets and questions. To use this system, go to the Support menu and select the “Help Center” option.  From this page, you can search the Knowledge Base articles, ask the community a question in the forum or submit a trouble ticket.

Other options under the Support menu include the following:

  1. Installation and Getting Started
  2. Licensing
  3. Tutorial Videos
  4. Forum
  5. Release Notes

The Licensing section will answer your questions such as when you need a license, how many licenses you will need, how to activate your license keys, how to renew subscriptions and more.

Tutorial videos are available showing how to use specific components and tasks as well as how to activate license keys and more.

The forum gives you a place to ask the community questions about implementations or unexpected results you’re experiencing.

Release Notes        

We recommend that you look through the release notes when a new version of the COZYROC SSIS+ Suite becomes available.  The release notes document the new features and enhancements added to SSIS+ as well as fixes to problems you may have encountered.

Knowledge Base Articles 
  1. SSIS+ 1.7 Releases 
  2. SSIS+ 1.8 releases 
  3. SSIS+ 1.9 releases 
  4. What is the End of Life (EOL) schedule for each major version.      

    • Related Articles

    • What are the recommended steps for installation?

      Review the information on the Installation and Getting Started page; the Compatibility Chart is especially important.  This will ensure proper installation and configuration of your environment and ensure that the COZYROC SSIS+ Suite will work with ...
    • How to upgrade an existing COZYROC SSIS+ Suite installation to a higher version.

      Before upgrading your existing COZYROC SSIS+ Suite to a higher version, we recommend that you first review this entire page in detail.  Depending on your upgrade situation you may need to reference the Compatibility Charts on the Installation and ...
    • How To Verify the Release Installed for Visual Studio, SSDT, and COZYROC SSIS+

      Once you have verified which versions you have installed below, please jump over to our Compatibility Charts on the Installation and Getting Started page to make sure all of these component are compatible with each other. Demonstration Video ...
    • SSIS+ 1.7 Releases

      To make COZYROC's components available in the new SSDT 17 version, change the target platform version to one of the other three available options: SQL Server 2012, SQL Server 2014, or SQL Server 2016. SSIS+ 1.7 SR-1 Feb 23, 2018 Released COZYROC ...
    • Is it required to install SSDT on the SQL Server?

      SQL Server Development Tools (SSDT) will always need to be installed on the machine(s) where you design your packages. It allows you to design and deploy SSIS packages using Visual Studio. For SSIS+ releases prior to 2.0: If you are using Data Flow ...