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."
Restricted data type attribute violation for Redshift
-
firmex_fbi
- Posts: 1
- Joined: Mon 11 May 2020 16:43
Re: Restricted data type attribute violation for Redshift
Hello,
Unfortunately, we couldn't reproduce the issue.
To give you a detailed answer, we need the following:
- the script for creating tables in the data source (Redshift) and the destination database (mssql);
- description of field mapping or just attach the dtsx package.
Please send it to us through the contact form on our website: https://devart.com/company/contactform.html
wbr, Oleg
Devart Team
Unfortunately, we couldn't reproduce the issue.
To give you a detailed answer, we need the following:
- the script for creating tables in the data source (Redshift) and the destination database (mssql);
- description of field mapping or just attach the dtsx package.
Please send it to us through the contact form on our website: https://devart.com/company/contactform.html
wbr, Oleg
Devart Team