SSIS - Error not fired for Execute SQL Task

More
3 years 10 months ago #13870 by alexm
alexm created the topic: SSIS - Error not fired for Execute SQL Task
Hello,

We are using the Redshift OLEDB provider version 1.4.0.3392 in our SSIS ETL process.
However, we found that the Execute SQL task does not fire an error when there are multiple statements in the batch and the error occurs not in the first statement.

Example:
Create a test table in Redshift:
create table test
(
  testdate datetime not null,
  testvalue int not null
);
Create a simple package with one Execute SQL task which uses Redshift OLEDB provider in fastload mode:

File Attachment:

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

Redshift connection string: Data Source=xxxx.redshift.amazonaws.com;User ID=xxxx;Initial Catalog=dev;Provider=SQLOLEDBRSNP.1;Persist Security Info=True;Extended Properties="SSL=require;AWS_BUCKET=dev;xxxx;AWS_SECRET_KEY=xxxx;COMMAND_TIMEOUT=600;";
Put the following code into the task. The code fails when executed in Sql Workbench because null value is supplied for a non-nullable column testvalue in the 2nd insert:
BEGIN TRANSACTION;
  insert into test(testdate, testvalue) values (getdate(), 1);
 
  -- error expected:
  insert into test(testdate, testvalue) values (getdate(), null);
COMMIT;
After the package is executed, the Execute SQL task reports success:
<!-- ia0 -->2015-11-24 11_24_47-Data WareHouse (Running) - Microsoft Visual Studio.png<!-- ia0 -->
No row in inserted into the table which indicates that the transaction is actually rolled back.
Can anything be done to make the error fired?

Thank you very much in advance.
Attachments:

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

More
3 years 8 months ago #13883 by Moderator
Moderator replied the topic: Re: SSIS - Error not fired for Execute SQL Task
Hi! Thank you for bug report! We have fixed this bug in build 3418. The new build will be released shortly. To obtain a build before official release please contact our Support.

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

More
3 years 6 months ago #13894 by alexm
alexm replied the topic: Re: SSIS - Error not fired for Execute SQL Task
Thank you, confirmed that it works as expected now.

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

Time to create page: 0.058 seconds
Powered by Kunena Forum