SSIS - FastLoad - Issue with "!" symbol in strings

More
7 years 7 months ago #13888 by alexm
Hello,

We have discovered an issue with the Redshift OLEDB provider that we can't find a good workaround for:
When an exclamation mark is present in table data and we try to copy that over using SSIS FastLoad, the symbol "!" gets replaced with "\041".

Steps to reproduce:
Create source table in SQL Server:
Code:
CREATE TABLE TestTbl ( Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY, String NVARCHAR(255) NOT NULL )
Create destination table in Redshift:
Code:
CREATE TABLE TestTbl ( Id INT NOT NULL PRIMARY KEY, String NVARCHAR(1024) NOT NULL );
Prepare a simple DataFlow task in SSIS:

Attachment 519_8560959e0a6bb883e134022a68f3c1eb.jpg not found


The task copies all data from source to destination using SSIS Fast Load:

Attachment 474_28fe335fcfbd780b8eea6630cb2be227.jpg not found


Insert a row to Source:
Code:
insert into TestTbl(String) values ('Test!')
Run SSIS package...
Examine the destination using SQL Workbench:
<!-- ia0 -->2016-02-16 12_00_59-SQL Workbench_J Redshift- rdsdevph - Default.wksp.png<!-- ia0 -->
"Test\041" is displayed instead of "Test!".

Could you please suggest some viable workaround for this issue? We have tried a normal row-by-row load instead of Fast Load. It works, but it's immensely slower and does not perform well if much data are to be inserted.
If this is a bug, when do you expect this could be fixed?

Thank you very much for your assistance!

Regards,
Alexander.
Attachments:

Please Log in or Create an account to join the conversation.

More
7 years 4 months ago #13895 by Moderator
Hi! Thank you for letting us know about the defect! It was fixed in build 3440.

Please Log in or Create an account to join the conversation.

More
7 years 3 months ago #13900 by alexm
Thank you!
We will test the new build and let you know if there are any issues.

Please Log in or Create an account to join the conversation.

Time to create page: 0.164 seconds
Powered by Kunena Forum