Fixing "Failed to generate CREATE TABLE" error in Upsert Destination (VS2026)

SSIS PowerPack Troubleshooting
, , ,
1

Problem

When creating a new table in the Upsert Destination component, you may encounter the following message:

Failed to generate CREATE TABLE: Could not get destination column information because the mapping file was not specified.

Upsert destination error message
Upsert destination error message958×685 44.9 KB

This error prevents the automatic generation of the destination table.

Cause

This issue commonly occurs in the following environment configuration:

  1. SQL Server 2022 is used together with Visual Studio 2026.
  2. The installed ZappySys SSIS PowerPack version is older than 6.0.0.10308.

In this scenario, the component may fail to retrieve the column metadata required to generate the CREATE TABLE statement.

Solution

To resolve this problem, follow these steps:

  1. Install or update to the latest ZappySys SSIS PowerPack version 6.0.0.10308 or later. This version introduces support for SSIS 2025 / SQL Server 2025. See the release notes for more details.

  2. Change your Target Server Version to SQL Server 2025.

    Change Target Server Version
    Change Target Server Version1194×714 65.1 KB

  3. Restart Visual Studio after installing the update.

  4. Reopen your SSIS project and try generating the destination table again using the Upsert Destination component.

  5. After applying these changes, the component should correctly detect the destination columns and generate the CREATE TABLE statement without errors.

    Working example
    Working example958×685 49.1 KB

Still need help?

If the issue persists, please get in touch with our support team: