SSIS package works in Visual Studio 2022 but not from command line?
I have a snippet of a workload that involves importing data from a CSV file into a MySQL database via ODBC. When I run it within Visual Studio it works just fine but when I run it via DTexec.exe (64-bit) it fails with the following errors:
Description: The value of the property 'ExclusionGroup' is incorrect. Description: "ODBC Destination" failed validation and returned validation status "VS_ISCORRUPT".
Google tells me that I need to configure ExclusionGroup but I've never had to do this before in the 20 years of using SSIS so this feels like a red herring. Similarly Google results for VS_ISCORRUPT say that I must have edited a package XML file directly and messed it up, which I have not done.
This seems like a bog-standard data import process but these errors have me completely stumped. It seems like there's something else wrong but these are the errors that manifest so I'm troubleshooting them with no success.
Help?
The package is simple:
The details:
-the CSV file has approximately 180,000 rows
- the destination is a AWS Aurora MySQL 3.08.2 (MySQL 8.0.39 compatible)
- visual studio 2022 with SSIS extension 1.6.2 (64-bit)
- The ETL server is Windows Server 2019 with SSIS from SQL Server 2017
- MySQL Connector/ODBC 9.4 (64-bit)