Restricted data type attribute violation for Redshift
Posted: Mon 11 May 2020 16:58
I am trying to load data into Sql Server 2014 using the ODBC driver for Redshift. I am using VS 2017 (SSDT 2017).
The DSN was set up successfully, and connection test was successful.
In SSIS, when I run a preview of the query, it returns rows. But when I execute the package, it fails with the following error:
(typing relevant parts of error msg)
"Redshift ODBC source [117] Error: ODBC Error occurred. state: '07006'. Native Error code: 157933094. Devart ODBC Restricted data type attribute violation."
The DSN was set up successfully, and connection test was successful.
In SSIS, when I run a preview of the query, it returns rows. But when I execute the package, it fails with the following error:
(typing relevant parts of error msg)
"Redshift ODBC source [117] Error: ODBC Error occurred. state: '07006'. Native Error code: 157933094. Devart ODBC Restricted data type attribute violation."