05 Hindi | Execute SQL task in SSIS

Hindi | Execute SQL task in SSIS
Download the file\script used in the Video from below link
drive.google.com/drive/folder...
02 Hindi how to import a csv file into sql server using ssis: • 02 Hindi | how to impo...
Hindi Execute SQL task in SSIS
What is a SSIS execute SQL task?
What is the difference between execute T SQL task and execute SQL task?
What is the difference between execute SQL task and Oledbcommand in SSIS?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@anamikatyagi8660]

Really a big fan of yours..you are doing a great job thanks for that 😊👍

[@Riya07109]

Finally, You uploaded video. I was waiting for next video that I can learn more on this topic.
Thank you 💥👍

[@learnssis]

Thank you Riya, Good to know that you are liking the videos in hindi.

[@suyogsawale8700]

Actually, You Made a great video and You Explained Each Term in Details, I also Prefer Videos in Hindi Because To Understand the Concept is Important and Your Way of Explanation is Really Fabulous
Keep it up
One day Definitely Views Will Increase

[@learnssis]

Thank you Suyog.

[@nithishdpsnithu7623]

Well explained bro thank you 😊

[@AnkitChaudhary_Vlogs]

I learn SSIS from your channel ❤❤❤❤

[@learnssis]

Its so nice of you Ankit.

[@AnkitChaudhary_Vlogs]

Wow 🤩 ❤ really very appreciate

[@learnssis]

Thank you Ankit Chaudhary.

[@AnkitChaudhary_Vlogs]

Sir I am requesting you
I got job in SSIS
I watched your video on TH-cam
But I am getting some common issue , so I request you to please make a full length video for SSIS and try to cover all topic , and make the video in Hindi language , I analysis some information on the TH-cam , No one is there like you , lots of students will learn SSIS/SSRS things from your videos , so I request you to please create a video approximately 10 Hours , it will be easy to watch your video , then lots of people can implement some project in real time ❤❤❤❤
Please make a full length video in Hindi for SSIS

[@learnssis]

@@AnkitChaudhary_Vlogs I am trying to make videos on separate topics individually because for example if a person needs information on foreach loop or on deployment then he can easily search the topic and can watch only that video. If I will try to make a single video that will be of 20-30 hours long and most of the people won't be able to watch it.

[@nithishdpsnithu7623]

Bro please make a video on how package deployment and sql server agent job in Hindi!

[@learnssis]

Yeah will try to cover all topics for sure.

[@amitsingh0169]

Hi you pls upload on video on SCD type 3. with this example.
OLTP
Depttbl
dno,dname,loc
10,maths,hyd
20,science,che
DWH
Depttype3 blank
dno,dname,loc,prevloc
if business user we need to track loc at any point of time with latest 2 versions
field- t3 field - loc
1.
design df and when you execute for first time
DWH
Depttype3 blank
dno,dname,loc,prevloc
10,maths,hyd,null
20,science,che,null
2. in SSMS update depttbl set loc='mum' where dno=10
OLTP
Depttbl
dno,dname,loc
10,maths,mum
20,science,che
DWH
Depttype3 blank
dno,dname,loc,prevloc
10,maths,hyd,null
20,science,che,null
execute same package for second time
DWH
Depttype3
dno,dname,loc,prevloc
10,maths,mum,hyd
20,science,che,null
3.in SSMS update depttbl set loc='goa' where dno=10
OLTP
Depttbl
dno,dname,loc
10,maths,goa
20,science,che
DWH
Depttype3 blank
dno,dname,loc,prevloc
10,maths,mum,hyd
20,science,che,null
execute same package for third time
DWH
Depttype3 blank
dno,dname,loc,prevloc
10,maths,goa,mum
20,science,che,null