Error Message: Failed to retrieve active package
Action:
When executing an SSIS package containing a COZYROC task and/or component, the following error is encountered.
Error Message:
Parallel Loop Task: Error: An error occurred with the following error message: "Failed to retrieve active package."
Solutions:
This error can occur for the following reasons:
- An incomplete installation - during the installation, the SSIS+ Library was not selected at the Customer Setup window
To resolve this issue, you need to
uninstall your current version of COZYROC SSIS+ and then install the COZYROC
SSIS+ suite again. You should keep all installation defaults during the
installation process.
- Incompatible SQL Server Data Tools (SSDT)
To resolve this problem,
you will need to uninstall the current version of SSDT and
the COZYROC SSIS+ Suite. Afterwards, reinstall SSDT and the
COZYROC SSIS+ Suite. On the Installation and Getting Started page, you will find a compatibility
chart with information on which version and/or release is supported by which
COZYROC SSIS+ Suite. The table is provided to help ensure proper installation
and configuration of your environment, which is necessary to ensure that
the COZYROC SSIS+ Suite will work in your environment.
Although SSDT is backward compatible, not every SQL Server version is supported. In order to avoid compatibility issues, install the COZYROC SSIS+ Suite recommended for the SSDT version.
- A recent SSDT upgrade or automatic SQL Server patch/update (can be part of a Windows Update)
To resolve this issue, please run CZSSISPlus_Restore.bat as
Administrator. In the latest SSIS+ builds, it can be found in your COZYROC
SSIS+ installation directory, but you can also download it from here. You can
schedule the BAT file to also run automatically after Windows updates.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
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 ...Error Message: Retrieve the COM class factory for component with CLSID failed due to the following error: 8007007e. The specified module could not be found.
Action: When I open my SSIS+ Package or when using Parallel Loop Task Editor Error Message: Retrieve the COM class factory for component with CLSID failed due to the following error: 8007007e. The specified module could not be found. Solution: To ...Error Message: The task with the name “XXXX” and the creation name “SSIS.ReplacementTask” is not registered for use on this computer.
Action: Attempting to open an SSIS package in Visual Studio you might get, under certain circumstances, the error below: Error Message: The task with the name “XXXX” and the creation name “SSIS.ReplacementTask” is not registered for use on this ...Error Message: "Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies”
Action: While using the OLE DB Destination inside of Data Flow Task Plus, the following error is encountered. Error Message: “Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its ...My Parallel Loop Task just stopped working.
The Parallel Loop Task may stop working if SQL Server SP is installed on the machine. Therefore it is mandatory the SSIS+ library is reinstalled after SQL Server update.