An error occurred while setting up a binding for the column

Hello Guys!

I just wanted to do this quick blog post to give you a tip about a recent problem that I had in a SSIS Project. My scenario is the following.

Source Database Server: PostgreSQL
Target Database Server: SQL Server 2016

As you can see, I need to extract data from this PostgreSQL database and import in SQL Server. So far everything is working, but today I got this error of in one particular table: [OLE DB Destination [25]] Error: An error occurred while setting up a binding for the “MyColumnName” column. The binding status was “DT_NTEXT”. The data flow column type is “DBBINDSTATUS_UNSUPPORTEDCONVERSION”. The conversion from the OLE DB type of “DBTYPE_IUNKNOWN” to the destination column type of “DBTYPE_WVARCHAR” might not be supported by this provider.

From what I understood it says this Data Type that the OLE DB Provider tried to convert from the source data is not supported and it resulted in a Unknown data type, which is not supported by the provier. So, how to deal with this problem?

Basically, what I did was creating an intermediate data converstion step as you can see in the below screen.

image

And for the necessary column, I have converted to a known data type that the OLE DB Provider will understand, which in this case is a DT_WSTR (NVARCHAR)

image

This fixed my error and I was able to execute the data flow task.

image

If you liked or not, give your feedback in the comments.

Regards,
Marcos Freccia
Data Platform MVP

Advertisements

About Marcos Freccia

MVP em SQL Server (Data Plataform) , especialista em SQL Server, e atualmente trabalhando com Microsoft Azure!

Posted on July 28, 2017, in VirtualPass, SQL Server, Integration Services, Dicas, SQL Server 2016 and tagged , , , , , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: