ODBC Destination” failed validation and returned validation status “VS_ISCORRUPT

There seems to be a bug with SQL Server Data Tools 15.8.1+ and the ODBC Destination task.  SSIS reports an error when writing to an ODBC Destination using the Destination Task.  The error is ‘ExclusionGroup’ is incorrect followed by “VS_ISCORRUPT”.

As of now, the only solution I’ve found is to use SSDT 15.8.0..  However, 3rd party components might work.  For example, I’ve tested the Cozyroc ODBC Destination and it works fine with SSDT15.8.1.

Leave a Reply

Your email address will not be published. Required fields are marked *