SQL Server Integration Services (SSIS) Part 10 - Sequence Containers and FOR Loops

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ธ.ค. 2024

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

  • @jahangirkabir9271
    @jahangirkabir9271 6 ปีที่แล้ว +2

    Great video saving life! God bless you, Sir.

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

    When searching for primes, you can increase the testnumber with 2 every time, since an odd number can’t be a multiplum of only even numbers.
    The initiation should check wether the limit is >=2, since 2 is not an odd number smaller than 1.

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

      As a maths graduate, Andy B will be devastated to learn that he has made such a schoolboy error!

  • @pratapchava1
    @pratapchava1 8 ปีที่แล้ว +13

    I hope this was useful..
    For Script task1:
    int TestNumber=Convert.ToInt32(Dts.Variables["User::TestNumber"].Value);
    int i;
    bool IfPrime = true;
    for (i = 2; i

  • @haatpraat530
    @haatpraat530 7 ปีที่แล้ว +2

    Perhaps when mentioning Sequence Containers transaction processing can also be mentioned. You could have say 3 different Execute SQL tasks in a Sequence Container that update a table. If the transaction property of the Sequence Container is set to 'required', then if any of the tasks fails within the Sequence Container ALL of the work of those tasks are rolled back.

  • @mrleokarthik
    @mrleokarthik 9 ปีที่แล้ว +5

    Excellent Tutorial for beginners, Can you provide SSIS files from all the lessons.

    • @marvid008
      @marvid008 7 ปีที่แล้ว

      Karthikeyan Shivasankaran bh

  • @DesiHoonMain
    @DesiHoonMain 8 ปีที่แล้ว

    Great tutorial series

  • @ravikonda8835
    @ravikonda8835 10 ปีที่แล้ว

    Thanks for this tutorial

  • @abhimanyusharma8097
    @abhimanyusharma8097 8 ปีที่แล้ว

    Where to get this prime no code??

  • @Anatoli8888
    @Anatoli8888 7 ปีที่แล้ว +2

    It's getting a bit harder because one have to add manually a lot of code to get it to work. While this is fun and good learning, for demonstrating certain features, perhaps some code could be provided? It was perfect, until this tutorial. Thank you, anyway.

    • @rafozoid
      @rafozoid 7 ปีที่แล้ว

      I struggled with some code on other tutorials. Found some on the internet and others I had to guess what was hidden...
      Anyways, Great tutorials!

  • @UriGerhard
    @UriGerhard 8 ปีที่แล้ว +3

    What's up with the audio on this one?

    • @feelingeverfine
      @feelingeverfine 6 ปีที่แล้ว

      Change it to 1.25 and it sounds a little better.

  • @lion0yury
    @lion0yury 5 ปีที่แล้ว

    too much of C#...