Restricted data type attribute violation for Redshift

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
firmex_fbi
Posts: 1
Joined: Mon 11 May 2020 16:43

Restricted data type attribute violation for Redshift

Post by firmex_fbi » 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."

oleg0k
Devart Team
Posts: 43
Joined: Wed 11 Mar 2020 08:28

Re: Restricted data type attribute violation for Redshift

Post by oleg0k » Thu 14 May 2020 13:29

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

Post Reply