1
I am using SQL Server Integration Services (SSIS) with SQL Server Data Tools (graphical component for Visual Studio 2015).
Within my processing package (SSIS) I have streams that, depending on the condition set the respective Data Flow Task is triggered.
Each Data Flow Task has basically a Flat File Source using ADO.Net Source and a Script Component, where I do the treatments using the C language#.
The processing stays in Loop, and basically does the following:
If file 1, go to Data Flow Task 1 (see image below);
If it is file 2, go to Data Flow Task 2 (see image below);
In all cases they should be inserted in the same table, but with different treatments due to business rules.
However, that’s where I’m in trouble. No flow error, describing better.
In case 1, the data is entered correctly after all rules are validated (see image below);
In case 2, the data not entered in the database, even after the rules have been validated (see image below)
An important addendum: If I delete or disable the first Data Flow Task, and have the package run again the second Data Flow Task (the second task) normally processes.
I already checked the encoding and no errors, I created even from scratch everything again, but nothing worked; I tried to find until some cache or reference that was wrong, but nothing was detected wrong.
So someone after understanding this whole process would know to tell me what’s going on?
Thank you for your attention.
I also tried to adjust by putting everyone inside the same Data Flow Task, but it still didn’t work. I tried another approach too by putting each Data Flow Task within a Sequence Container didn’t work either. All the other Tacks keep working perfectly.
– Alexandre Dórea