For Loop Container in SSIS Example [Real Time Example]

แชร์
ฝัง
  • เผยแพร่เมื่อ 13 ก.ค. 2024
  • In this video we have demonstrated complete example using for loop container in ssis example and this we did with a real time example.
    So here we written a query to get max quantity of a product purchase and by using max quantity value we iterated for loop from intial value to max quantity and for each quantity we created directory with a quantity name and same we iterated the data flow where we again queried sql table with quantity wise, so what-ever result we got we exported to Flat File using Flat File Destination and saved that file in a same directory.
    Please watch this video completely and understand for loop completely

ความคิดเห็น • 13

  • @nimikajadav3004
    @nimikajadav3004 17 วันที่ผ่านมา

    Great Explanation and very informative !

  • @baljeetmatta
    @baljeetmatta 3 ปีที่แล้ว +1

    Great Explanation, I can't expect better than this, Keep it up

  • @shalininagarajan6008
    @shalininagarajan6008 2 ปีที่แล้ว +1

    Great explanation...

  • @prameela5253
    @prameela5253 10 หลายเดือนก่อน

    Hi, Just now i saw your video its very helpful for me can you pls do video for remaining containers means foreach and sequence and can you pls do clear video seperately for data flow and seperately for control flow with live examples

  • @saketsrivastava84
    @saketsrivastava84 3 ปีที่แล้ว +1

    Nice video sir

    • @gurunathad13
      @gurunathad13  3 ปีที่แล้ว

      Thank you and Happy Learning !!!

  • @mustafakamal5945
    @mustafakamal5945 3 ปีที่แล้ว +1

    Great explanation :), where can I find a video on extracting multiple files and loading into SQL tables

  • @chandramoulik1988
    @chandramoulik1988 3 ปีที่แล้ว

    Good video bro. But, is there any way to use the for loop with string value incrementation.. Like if i = a, then a query should load and the result should save with name 'a'. Then, i value should increment to 'b', then a different query should be triggered..Likewise, loop should continue till end of the loop..??

  • @arunv1909
    @arunv1909 2 ปีที่แล้ว

    sadly mine didnt work in exe sql itself, it throws error

  • @rc.rchinni
    @rc.rchinni 3 ปีที่แล้ว +1

    I want to learn etl ssis

    • @gurunathad13
      @gurunathad13  3 ปีที่แล้ว

      Let me know your doubt will help you

  • @rc.rchinni
    @rc.rchinni 3 ปีที่แล้ว +1

    I want to talk with u