150 How to continue ssis package if a specific task fails

[@koushaljha4507]

This is very helpful..

[@learnssis]

Thank you Sir, sab aapse hi seekha he.

[@amythsharma6227]

Hi Sir , I created my first ssis package referring your videos this month ,imo you provide very crisp consise information being a newbie quite helpful, keep up the good work 👍🏻

[@learnssis]

Thank you Amyth Sharma.

[@Aeditya]

Thanks for the learning

[@learnssis]

You are most welcome.

[@blackisblack22]

I have a table with 4 rows defined as id (1..4) and a few columns with data. Each row launches an ole db source which reads the data in its corresponding row and makes a particular query to the database. What is the best way to run all four processes in parallel?

[@learnssis]

1. I will create a new sql table with column as Id. At a time it will have only 1 record and the value of Id can be updated by our process. I will insert 1 record to this table. 2. I will make an SSIS package which can get the current id from the sql table we just created. And now this package can makes a particular query to the database according to the id in the new table. 3. I will make a parent ssis package and will use the foreach loop container with ado enumerator. 4. In the select query we will select all ids from your table and will assign the result set to the object variable. 5. Now will use the foreach loop container with ado enumerator and will create a new ssis variable Id of int32 type. 6. will update the existing value of id in the new table by the id that we got in the ssis variable inside foreach loop container, we can use the execute sql task for this. 7. Now we will create a sql agent job and will call the ssis package from sql agent job. This is a one time task. 8. Now in the foreach loop container after updating the id in 6th step, at the next step we will call the sql agent job that we created in step 7. 9. This will kick of the ssis package and it will get the id from new table that we created. 10. Now in next iteration, it will update another id to the new table that we created and in the next step it will again call the sql agent job using the sql query and which will call the ssis package and the ssis package will pick the id from the new sql table.

[@blackisblack22]

@@learnssis Thank you very much for you kind response. The control table is already populated with 4 records wich will be read all at once, maybe using a script task. I was thinking in some kind of a split in the control flow tab instead of foreach but i’m sure that’s not possible. Maybe the foreach approach would be the only way to accomplish the task giving up parallelism.

[@learnssis]

@@blackisblack22 I know there is some threading available in C# but I have not used that much, so not sure how we can implement that.

[@sameerunawane]

sir suppose i have duplicate records and i want to assign unique key to all those records. how to handle this in SSIS because all are needed

[@learnssis]

just add an identity column to the sql table. alter table tablename add Id int identity

[@sameerunawane]

@@learnssis the query from which i am fetching records is a cte. the result changes everytime.so will the package be able to identify the pre-existing records

[@learnssis]

@@sameerunawane it does not matter whether it is a normal query or a cte, it will always get the current data in SSIS whatever data you will get when running the query on sql server management studio.