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.
