09 Precedence constraints in SSIS | SSIS real time scenarios

[@Fullon2]

Your videos are great friend, congratulations on your work, best SSIS content on youtube.

[@learnssis]

So nice to hear from you. Thank you so much.

[@suhaspotdar9784]

Video's are very helpful also need one real time scenario where we can use.

[@mmusciano]

We appreciate your contents very helpful!

[@learnssis]

Glad you liked the video.

[@gvscreations4182]

So useful ur videos and thanks for sharing ur Knowledge.....

[@learnssis]

You are most welcome gvs creations.

[@gvscreations4182]

Cross the youtube ur videos are the best 👌 and excellent 👌

[@learnssis]

Thank you so much for your kind words.

[@theparagbagga]

Thank you so much.. I was making a mistake by not selecting that or condition. Mine below two were not running. Was scratching my head from last 2 hours. Thanks alot.

[@learnssis]

Glad to know that it helped you Parag.

[@sandhyayerra9470]

Sir i have a doubt why two tasks are executing other than 1 if we put the and conditon .

[@learnssis]

Not sure how your data flow looks like.

[@wannuruladibah3049]

if there are 2 data in the database, one with value 1 and another one with value 2, both flow 1 and 2 will execute right?

[@learnssis]

Please test that. It will execute if value from database is matching with the condition in precedence constraints.

[@wannuruladibah3049]

@@learnssis is there a need to change the result set from single row to full result set? or is there any video that i can refer to for this result set settings?

[@wannuruladibah3049]

with that, i need to use logical or in the precedence constraints right

[@learnssis]

​@@wannuruladibah3049If a single value will be returned from the database then you can store it in a string variable and you can use single row. Full result set is used if multiple rows are returned from the database and to use them you would need to use the foreach loop ado enumerator.

[@wannuruladibah3049]

@@learnssis which video i can refer to to learn this in your channel?

[@entertainmentjunction3328]

Hlo sir please explain details about how to create dim and fact table and load the data from staging...plz plz

[@learnssis]

Hi, please take a look at below video in this I have shown how to load the data into Dim tables kzbin.info/www/bejne/m4XQcqGVqMqnfKs

[@gvscreations4182]

We paid lot of money for course but they didn't share these knowledge