- Thank you received: 0
SSIS - FastLoad - Issue with "!" symbol in strings
- alexm
- Topic Author
- Offline
- User
-
Less
More
7 years 7 months ago #13888
by alexm
SSIS - FastLoad - Issue with "!" symbol in strings was created 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:
Create destination table in Redshift:
Prepare a simple DataFlow task in SSIS:
The task copies all data from source to destination using SSIS Fast Load:
Insert a row to Source:
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.
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
)
Code:
CREATE TABLE TestTbl
(
Id INT NOT NULL PRIMARY KEY,
String NVARCHAR(1024) NOT NULL
);
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!')
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.
- Moderator
-
- Offline
- New Member
Less
More
- Thank you received: 0
7 years 4 months ago #13895
by Moderator
Replied by Moderator on topic Re: SSIS - FastLoad - Issue with "!" 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.
- alexm
- Topic Author
- Offline
- User
-
Less
More
- Thank you received: 0
7 years 3 months ago #13900
by alexm
Replied by alexm on topic Re: SSIS - FastLoad - Issue with "!" symbol in strings
Thank you!
We will test the new build and let you know if there are any issues.
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