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

More
3 years 2 months ago #13888 by alexm
alexm created the topic: SSIS - FastLoad - Issue with "!" symbol in strings
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:
CREATE TABLE TestTbl
(
	Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	String NVARCHAR(255) NOT NULL
)
Create destination table in Redshift:
CREATE TABLE TestTbl
(
	Id INT NOT NULL PRIMARY KEY,
	String NVARCHAR(1024) NOT NULL
);
Prepare a simple DataFlow task in SSIS:

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

File Attachment:

File Name: 474_28fe33...e227.jpg
File Size:102 KB

Insert a row to Source:
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
2 years 11 months ago #13895 by Moderator
Moderator replied the topic: Re: SSIS - FastLoad - Issue with &quot;!&quot; symbol in strings
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
2 years 10 months ago #13900 by alexm
alexm replied the topic: Re: SSIS - FastLoad - Issue with &quot;!&quot; symbol in strings
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.213 seconds
Powered by Kunena Forum