How to solve - The value of the property 'Exclusiongroup' is incorrect ?

Janakiraman Balasubramanian 0 Reputation points
2023-07-26T18:38:48.7433333+00:00

I had an SSIS package created with VS 2012 or older which transfers data from a flat file to a Teradata database (ODBC) . Used to work fine.

I upgraded to Visual Studio 2017 and had to edit the package and save it.

When I execute the package I get an error

The value of the property 'Exclusiongroup' is incorrect

ODBC destination failed. VS_ISCORRUPT.

I tried to create new in VS 2017 and get the same error.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,095 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,575 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 36,511 Reputation points
    2023-07-27T08:22:05.4733333+00:00

    Hi @Janakiraman Balasubramanian,

    Try to change the ODBC Source ValidateExternalMetadata property to False.

    Also, make sure that you have selected the right TargetServerVersion property from the project configuration.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

  2. Will Chen 145 Reputation points
    2023-07-27T03:02:43.21+00:00

    It appears that you're dealing with an issue related to the 'Exclusiongroup' property, but without specific context (like the software or language you're using), it's difficult to provide an exact solution. However, this error generally indicates that the value assigned to the 'Exclusiongroup' property is not valid or not expected by the system.

    Here are some general troubleshooting steps you could consider:

    Review the assigned value: Check the value you have set for 'Exclusiongroup'. Make sure it aligns with the expected data type (like string, integer, boolean, etc.) and the accepted range of values.

    Check for typos or syntax errors: Sometimes a simple typo or an error in the syntax can cause issues. Make sure the property name and value are spelled correctly and follow the correct syntax for your specific language or framework.

    Read the documentation: Check the documentation of the software or language you're using for guidelines on how to correctly use the 'Exclusiongroup' property.

    Look for dependencies: The 'Exclusiongroup' property may depend on other settings or properties. Make sure all prerequisites or dependencies are correctly set up.

    1. Ask for help: If you're still struggling to solve the problem, consider asking for help on a relevant forum or community (like Stack Overflow or a relevant subreddit). When asking for help, make sure to provide all relevant information about your situation, including the exact error message, the software or language you're using, and what you've already tried to solve the problem.

    Thanks!

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.