For Each Loop Task | Control Flow Task in SSIS Tutorial (14/25)

[@helen119]

NAGS IS AMAZING, I had to just add a comment on his page. He is so good, he knows his stuff....thank you

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@AnilKumar-tn7sp]

Hi Sir. Have a doubt that need how to add db_ssisoperator role access to user to monitor and execute ssis packages

[@AnalyticswithNags]

In logins of the user add the role

[@kishanbhise4733]

This is really good explanation ! Thanks sir

[@AnalyticswithNags]

Thanks keep learning

[@parij4840]

Nice Explanation.. Great Effort..

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@parij4840]

@@AnalyticswithNags sure

[@raviranjansingh5527]

Thanks sir updating daily videos. Way of explaining is great.

[@AnalyticswithNags]

Thank you, Share it with friends

[@saikrishnareddy6405]

Sir, how to load a flat file if the files are enclosed by single or double quotes. For eg:
Id | Name | sal
1 | 'Ram' | 20000
2 | ' krishna' | 10000
When I load the data with the single quotes then in sql table name column values are storing with single quotes for eg:
1 , ' Ram' , 20000
2, ' KRISHNA',10000
THE result should be without quotes.
Please suggest sir.

[@AnalyticswithNags]

Use text qualifier as ‘

[@saikrishnareddy6405]

thanks a lot sir.

[@ronydominic4873]

Hi Sir thank you so much for the great efforts in making the videos, however I've a small suggestion, SSIS tutorial is too fast for a beginner like me, it is really tough to keep up with the pace, It would be really great if you could slow the pace and explain the options which you're clicking so that a beginner like me can also follow, thanks a lot sir.

[@AnalyticswithNags]

I understand your concern. Now a days ensure to highlight the options that highlight. Keep learning share this channel with friends and colleagues

[@kishanbhise4733]

Hi Sir,This works if the table structure for each file is same ,how to add files with different table structures in different tables of same database dynamcally using ForEachLoop Container,

[@AnalyticswithNags]

Ssis is more metadata dependent. So columns names are saved in SSIS. For each file with different columns there should be separate data flow

[@kishanbhise4733]

@@AnalyticswithNags okay got it Thank you sir

[@dilipkumar-ck1nc]

1st task is successfully completed second task derived column is not successful what ever in the video it is there I do the same
Error: create new column values by applying expression to transformation input columns
It was not showing any error in dataflow
While executed it throwing an error

[@AnalyticswithNags]

Not sure can’t help much

[@dilipkumar-ck1nc]

@@AnalyticswithNags variable is not passing that is error derived column showing error