Do we need to rebuild SSIS packages when upgrading the ZappySys SSIS PowerPack?

SSIS PowerPack
, ,
1

No, you generally do not need to rebuild your SSIS packages when upgrading the ZappySys SSIS PowerPack. You simply need to uninstall the previous version and install the latest one. Your existing packages should continue to work as expected without any changes.

The standard procedure involves:

  1. Uninstall the Previous Version Using Control Panel
    Go to Control Panel → Programs and Features, locate ZappySys SSIS PowerPack, and select Uninstall. This helps ensure a clean installation of the new version.

  2. Download and Install the New Version
    After uninstalling the previous version, run the installer for the new version you downloaded. Follow the prompts and choose the Typical (Default) installation settings unless you have specific configuration needs.

Once the new version is installed, your existing SSIS packages, which utilize ZappySys components, should continue to function without requiring you to open them in Visual Studio (SSDT), re-save them, or re-deploy them. We design our components with a strong focus on backward compatibility to facilitate smoother upgrades for our users.

However, the primary challenge arises from version mismatches, particularly when deploying packages developed with a newer PowerPack version (e.g., v5.6.0) to an environment with an older version (e.g., v4.2.0). And you face the following error:

The component metadata for JSON Source (REST API or File), clsid {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}’ could not be upgraded to the newer version of the component. The PerformUpgrade method failed.

To resolve this error, please refer to the following article for step-by-step guidance:
Fixing the ZappySys SSIS Error: “Component Metadata Could Not Be Upgraded”

Best practice to upgrade the ZappySys PowerPack

Here are some recommended best practices for upgrading the ZappySys SSIS PowerPack:

  1. Test in a Development or Test Environment First
    Before upgrading in a production environment, we recommend testing the latest version on a development machine or test server to ensure compatibility.

  2. Check Compatibility
    Review the release notes and system requirements of the new version to confirm it’s compatible with your current setup.

  3. Backup Existing Configuration
    Before proceeding with the upgrade, take a backup of your existing SSIS packages, configuration files, and PowerPack settings. This helps ensure a smooth rollback if needed.

  4. Uninstall the Previous Version
    It’s best to uninstall the current version from the Control Panel before installing the new one. This helps avoid version conflicts and ensures a clean upgrade process.

  5. Temporarily Disable Antivirus Software
    In some cases, antivirus software may interfere with the installation. Consider temporarily disabling it during the upgrade to prevent any interruptions.

  6. Install the Latest Version
    Once you’ve completed the above steps, install the new version of the PowerPack using the installation wizard. Follow the prompts and select options based on your system setup.

  7. Test the Installation
    After installation, thoroughly test your packages and key features to confirm everything is working as expected in the upgraded environment.

  8. Have a Rollback Plan
    As a precaution, keep a copy of the previous installer and configuration backups in case you need to revert to the earlier version.

Steps to Follow When Updating ZappySys SSIS PowerPack on Your Machine:

  1. Download the Required Version
    Download the latest or specific version of the ZappySys SSIS PowerPack to your machine.

  2. Stop Related Services and Applications

    • On the server, stop any running jobs that use ZappySys PowerPack components, and close any open instances of Visual Studio and SQL Server.
    • On a development machine, simply close Visual Studio and SQL Server if they are open.

  3. Uninstall the Current Version
    Navigate to Control Panel → Programs and Features, locate ZappySys SSIS PowerPack, and uninstall it.

  4. Install the New Version
    Run the downloaded installer and proceed with the installation using the Typical (Default) settings.

  5. Restart Services and Validate
    On the server, restart the previously stopped jobs and test them.
    Note: There is no need to rebuild any of your existing SSIS packages—the updated PowerPack will work with them as-is.

Following these steps can help ensure a smooth and reliable upgrade process. If you run into any issues or have questions during the upgrade, feel free to reach out. We’re here to help!

Helpful Links