ETL and Data Integration tools - Modern ETL software for everyone

I am currently having an issue with one of my packages.

It contains an import and a delete

The issue I am having is that the package is failing on the import due to a foreign key constraint.

In the properties for the import “Fail on import error” is not checked.

I did have it checked originally, but I turned it off and still the package failed.

I even tried removing the import from the package and re-adding it, but that didn’t work either.

I am new to this version, I was using an older version for a while and it did not have the “fail on import error” checkbox.

The way it handled this issue was, it would put the file that got rejected into the rejection log, but still continue with the transformation of the other files and still continue with the delete.

The transformation was rolled back.

Tim

Tim

Assuming that Data target of the import is ODBC can you try the following please

Open import
Click data target options
Click connection
Select Commit every statement
Click Error Handling
Untick Abort Import

Please let us know the outcome

Peter

The import is MS SQL.

When I try to select Commit every statement and then hit ok, it never saves it.
Every time I go back into the options it goes back to \"once import is completed.\"

Also abort Import is Unticked.

>When I try to select Commit every statement and then hit ok, it never saves it.

This problem was corrected in latest version.

Please download, install it and let us know the outcome.

I am confused of what is happening.

So You have a package with two objects

One of them import
Another SQL script

Import is failing due to foreign key constraints

Are you saying that next step is never executed?

Is your import loading data from multiple data files/tables?

Peter

The latest version seemed to fix it for me thanks!

The package contains a MS SQL Import, which is importing csv files from a specific directory. As well as a file operation, delete, which deletes the CSV files after they are imported.
This package runs every 5 minutes so there could be multiple CSV files, each with multiple rows of data.

What was happening was the import would fail due to one record being rejected for a foreign key, the whole import would be rolled back, and the package would then stop because the delete was only on success. The import failed as a whole, even though the fail event was unchecked in the advanced properties of the import as well as abort import was unchecked in the connection options.