home.social

#ssis — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #ssis, aggregated by home.social.

  1. Headline: SSIS Is Not Dead. Yet.

    Me: Since Microsoft discontinued SSRS for the SQL Server 2025 release, many have been wondering if SSIS' days are numbered. Here's another article prognosticating what comes next.

    More SSIS Thoughts: (continued in thread)

    sqlfingers.com/2026/03/ssis-is

    #SQLServer
    #SSIS
    #ETL

  2. Headline: SSIS Is Not Dead. Yet.

    Me: Since Microsoft discontinued SSRS for the SQL Server 2025 release, many have been wondering if SSIS' days are numbered. Here's another article prognosticating what comes next.

    More SSIS Thoughts: (continued in thread)

    sqlfingers.com/2026/03/ssis-is

    #SQLServer
    #SSIS
    #ETL

  3. Headline: SSIS Is Not Dead. Yet.

    Me: Since Microsoft discontinued SSRS for the SQL Server 2025 release, many have been wondering if SSIS' days are numbered. Here's another article prognosticating what comes next.

    More SSIS Thoughts: (continued in thread)

    sqlfingers.com/2026/03/ssis-is

    #SQLServer
    #SSIS
    #ETL

  4. Headline: SSIS Is Not Dead. Yet.

    Me: Since Microsoft discontinued SSRS for the SQL Server 2025 release, many have been wondering if SSIS' days are numbered. Here's another article prognosticating what comes next.

    More SSIS Thoughts: (continued in thread)

    sqlfingers.com/2026/03/ssis-is

    #SQLServer
    #SSIS
    #ETL

  5. Headline: SSIS Is Not Dead. Yet.

    Me: Since Microsoft discontinued SSRS for the SQL Server 2025 release, many have been wondering if SSIS' days are numbered. Here's another article prognosticating what comes next.

    More SSIS Thoughts: (continued in thread)

    sqlfingers.com/2026/03/ssis-is

    #SQLServer
    #SSIS
    #ETL

  6. As an #introduction since the migration doesn't bring my history over. Hi all and #BeigeBless I am delighted to join this eclectic server and hope that I can live up to the high standards.

    I am a medium old (re-entered the prime decades) white guy living in the middle of the US but don't hold that against me. Married, two kids that aren't exactly "kids". I used to talk a lot about #SSIS, #SQLServer, #python, C#, #Databricks but anymore I think just chat about what's going on in my life.

    My newest joy has been my backyard chickens and not maintaining the website 816chickens.com/

    Undecided on me? Here's my easy follow criteria for you

    Tea not coffee
    Trans rights are human rights
    The president is a bag of dicks

  7. As an #introduction since the migration doesn't bring my history over. Hi all and #BeigeBless I am delighted to join this eclectic server and hope that I can live up to the high standards.

    I am a medium old (re-entered the prime decades) white guy living in the middle of the US but don't hold that against me. Married, two kids that aren't exactly "kids". I used to talk a lot about #SSIS, #SQLServer, #python, C#, #Databricks but anymore I think just chat about what's going on in my life.

    My newest joy has been my backyard chickens and not maintaining the website 816chickens.com/

    Undecided on me? Here's my easy follow criteria for you

    Tea not coffee
    Trans rights are human rights
    The president is a bag of dicks

  8. As an #introduction since the migration doesn't bring my history over. Hi all and #BeigeBless I am delighted to join this eclectic server and hope that I can live up to the high standards.

    I am a medium old (re-entered the prime decades) white guy living in the middle of the US but don't hold that against me. Married, two kids that aren't exactly "kids". I used to talk a lot about #SSIS, #SQLServer, #python, C#, #Databricks but anymore I think just chat about what's going on in my life.

    My newest joy has been my backyard chickens and not maintaining the website 816chickens.com/

    Undecided on me? Here's my easy follow criteria for you

    Tea not coffee
    Trans rights are human rights
    The president is a bag of dicks

  9. As an #introduction since the migration doesn't bring my history over. Hi all and #BeigeBless I am delighted to join this eclectic server and hope that I can live up to the high standards.

    I am a medium old (re-entered the prime decades) white guy living in the middle of the US but don't hold that against me. Married, two kids that aren't exactly "kids". I used to talk a lot about #SSIS, #SQLServer, #python, C#, #Databricks but anymore I think just chat about what's going on in my life.

    My newest joy has been my backyard chickens and not maintaining the website 816chickens.com/

    Undecided on me? Here's my easy follow criteria for you

    Tea not coffee
    Trans rights are human rights
    The president is a bag of dicks

  10. As an #introduction since the migration doesn't bring my history over. Hi all and #BeigeBless I am delighted to join this eclectic server and hope that I can live up to the high standards.

    I am a medium old (re-entered the prime decades) white guy living in the middle of the US but don't hold that against me. Married, two kids that aren't exactly "kids". I used to talk a lot about #SSIS, #SQLServer, #python, C#, #Databricks but anymore I think just chat about what's going on in my life.

    My newest joy has been my backyard chickens and not maintaining the website 816chickens.com/

    Undecided on me? Here's my easy follow criteria for you

    Tea not coffee
    Trans rights are human rights
    The president is a bag of dicks

  11. SSIS в Visual Studio: как мы перешли от хаоса к стабильному ETL-процессу

    Можно ли хранить данные, строить по ним отчетность, при этом обходясь без ETL процессов? Технически — да. Практически — только до первого серьезного роста данных. Привет, Хабр! Меня зовут Алина, и в этой статье я расскажу о критически важном этапе, через который проходит любая data-driven компания. Речь о переходе: от построения отчетности напрямую из операционных баз (или через примитивное копирование в STG) к структурированным ETL-процессам на специализированном ПО. В нашем случае этим ПО стал SSIS — но важно подчеркнуть: сейчас мы используем NiFi с [N] процессорами для управления data pipeline. Однако именно опыт с SSIS стал для нас тем самым «мостиком» между хаотичным и осознанным подходом к данным. P.S. Если хотите узнать про то, как мы организовали работу в NiFi — пишите в комментах, сделаем отдельный материал! В этой статье — только про этап с SSIS. Не потому что он «лучший», а потому что:

    habr.com/ru/articles/927416/

    #etlпроцессы #ssis #sql #data_engineering #базы_данных

  12. SSIS в Visual Studio: как мы перешли от хаоса к стабильному ETL-процессу

    Можно ли хранить данные, строить по ним отчетность, при этом обходясь без ETL процессов? Технически — да. Практически — только до первого серьезного роста данных. Привет, Хабр! Меня зовут Алина, и в этой статье я расскажу о критически важном этапе, через который проходит любая data-driven компания. Речь о переходе: от построения отчетности напрямую из операционных баз (или через примитивное копирование в STG) к структурированным ETL-процессам на специализированном ПО. В нашем случае этим ПО стал SSIS — но важно подчеркнуть: сейчас мы используем NiFi с [N] процессорами для управления data pipeline. Однако именно опыт с SSIS стал для нас тем самым «мостиком» между хаотичным и осознанным подходом к данным. P.S. Если хотите узнать про то, как мы организовали работу в NiFi — пишите в комментах, сделаем отдельный материал! В этой статье — только про этап с SSIS. Не потому что он «лучший», а потому что:

    habr.com/ru/articles/927416/

    #etlпроцессы #ssis #sql #data_engineering #базы_данных

  13. SSIS в Visual Studio: как мы перешли от хаоса к стабильному ETL-процессу

    Можно ли хранить данные, строить по ним отчетность, при этом обходясь без ETL процессов? Технически — да. Практически — только до первого серьезного роста данных. Привет, Хабр! Меня зовут Алина, и в этой статье я расскажу о критически важном этапе, через который проходит любая data-driven компания. Речь о переходе: от построения отчетности напрямую из операционных баз (или через примитивное копирование в STG) к структурированным ETL-процессам на специализированном ПО. В нашем случае этим ПО стал SSIS — но важно подчеркнуть: сейчас мы используем NiFi с [N] процессорами для управления data pipeline. Однако именно опыт с SSIS стал для нас тем самым «мостиком» между хаотичным и осознанным подходом к данным. P.S. Если хотите узнать про то, как мы организовали работу в NiFi — пишите в комментах, сделаем отдельный материал! В этой статье — только про этап с SSIS. Не потому что он «лучший», а потому что:

    habr.com/ru/articles/927416/

    #etlпроцессы #ssis #sql #data_engineering #базы_данных

  14. SSIS в Visual Studio: как мы перешли от хаоса к стабильному ETL-процессу

    Можно ли хранить данные, строить по ним отчетность, при этом обходясь без ETL процессов? Технически — да. Практически — только до первого серьезного роста данных. Привет, Хабр! Меня зовут Алина, и в этой статье я расскажу о критически важном этапе, через который проходит любая data-driven компания. Речь о переходе: от построения отчетности напрямую из операционных баз (или через примитивное копирование в STG) к структурированным ETL-процессам на специализированном ПО. В нашем случае этим ПО стал SSIS — но важно подчеркнуть: сейчас мы используем NiFi с [N] процессорами для управления data pipeline. Однако именно опыт с SSIS стал для нас тем самым «мостиком» между хаотичным и осознанным подходом к данным. P.S. Если хотите узнать про то, как мы организовали работу в NiFi — пишите в комментах, сделаем отдельный материал! В этой статье — только про этап с SSIS. Не потому что он «лучший», а потому что:

    habr.com/ru/articles/927416/

    #etlпроцессы #ssis #sql #data_engineering #базы_данных

  15. I spent some time today trying to see if #Biml would be a good match for this #SSIS project I'm on. Probably not due to weird data sources, but it struck me--At no point during this development has a tool attempted to *help* me by guessing what I'm going to type, suggesting non-existent syntax, etc.

    It's just me and a blank canvas. Kind of nice TBQH

  16. I spent some time today trying to see if #Biml would be a good match for this #SSIS project I'm on. Probably not due to weird data sources, but it struck me--At no point during this development has a tool attempted to *help* me by guessing what I'm going to type, suggesting non-existent syntax, etc.

    It's just me and a blank canvas. Kind of nice TBQH

  17. I spent some time today trying to see if #Biml would be a good match for this #SSIS project I'm on. Probably not due to weird data sources, but it struck me--At no point during this development has a tool attempted to *help* me by guessing what I'm going to type, suggesting non-existent syntax, etc.

    It's just me and a blank canvas. Kind of nice TBQH

  18. I spent some time today trying to see if #Biml would be a good match for this #SSIS project I'm on. Probably not due to weird data sources, but it struck me--At no point during this development has a tool attempted to *help* me by guessing what I'm going to type, suggesting non-existent syntax, etc.

    It's just me and a blank canvas. Kind of nice TBQH

  19. I spent some time today trying to see if #Biml would be a good match for this #SSIS project I'm on. Probably not due to weird data sources, but it struck me--At no point during this development has a tool attempted to *help* me by guessing what I'm going to type, suggesting non-existent syntax, etc.

    It's just me and a blank canvas. Kind of nice TBQH

  20. This reminds me of #SSIS development back in the day. Do *anything* and Visual Studio locks up for an indeterminate amount of time.

  21. This reminds me of #SSIS development back in the day. Do *anything* and Visual Studio locks up for an indeterminate amount of time.

  22. This reminds me of #SSIS development back in the day. Do *anything* and Visual Studio locks up for an indeterminate amount of time.

  23. This reminds me of #SSIS development back in the day. Do *anything* and Visual Studio locks up for an indeterminate amount of time.

  24. This reminds me of #SSIS development back in the day. Do *anything* and Visual Studio locks up for an indeterminate amount of time.

  25. Following other's examples, I have updated my #StackOverflow profile to indicate it's now dormant (until I migrate the question and answers to my personal blag and then request deletion).

    Overall, the experience was net positive for me. It helped me become a SQL Server MVP. I learned a ton about #SSIS. Most importantly, I learned how to help people define their question so it can be answered. Crucial for consulting.

    All these moments will be lost in time, like tears in the rain.

  26. Following other's examples, I have updated my #StackOverflow profile to indicate it's now dormant (until I migrate the question and answers to my personal blag and then request deletion).

    Overall, the experience was net positive for me. It helped me become a SQL Server MVP. I learned a ton about #SSIS. Most importantly, I learned how to help people define their question so it can be answered. Crucial for consulting.

    All these moments will be lost in time, like tears in the rain.

  27. Following other's examples, I have updated my #StackOverflow profile to indicate it's now dormant (until I migrate the question and answers to my personal blag and then request deletion).

    Overall, the experience was net positive for me. It helped me become a SQL Server MVP. I learned a ton about #SSIS. Most importantly, I learned how to help people define their question so it can be answered. Crucial for consulting.

    All these moments will be lost in time, like tears in the rain.

  28. Following other's examples, I have updated my #StackOverflow profile to indicate it's now dormant (until I migrate the question and answers to my personal blag and then request deletion).

    Overall, the experience was net positive for me. It helped me become a SQL Server MVP. I learned a ton about #SSIS. Most importantly, I learned how to help people define their question so it can be answered. Crucial for consulting.

    All these moments will be lost in time, like tears in the rain.

  29. Following other's examples, I have updated my #StackOverflow profile to indicate it's now dormant (until I migrate the question and answers to my personal blag and then request deletion).

    Overall, the experience was net positive for me. It helped me become a SQL Server MVP. I learned a ton about #SSIS. Most importantly, I learned how to help people define their question so it can be answered. Crucial for consulting.

    All these moments will be lost in time, like tears in the rain.

  30. I did a cool thing at work today: I prototyped compressing large-ish amounts of data from from #SSIS into #Parquet files. SSIS doesn’t have any parquet support so I used CSV as a go-between and #Python to get the data into parquet. 8.5 million records compressed from almost 3 GB down to 180 MB is pretty awesome.

  31. I did a cool thing at work today: I prototyped compressing large-ish amounts of data from from #SSIS into #Parquet files. SSIS doesn’t have any parquet support so I used CSV as a go-between and #Python to get the data into parquet. 8.5 million records compressed from almost 3 GB down to 180 MB is pretty awesome.

  32. I did a cool thing at work today: I prototyped compressing large-ish amounts of data from from #SSIS into #Parquet files. SSIS doesn’t have any parquet support so I used CSV as a go-between and #Python to get the data into parquet. 8.5 million records compressed from almost 3 GB down to 180 MB is pretty awesome.

  33. I did a cool thing at work today: I prototyped compressing large-ish amounts of data from from #SSIS into #Parquet files. SSIS doesn’t have any parquet support so I used CSV as a go-between and #Python to get the data into parquet. 8.5 million records compressed from almost 3 GB down to 180 MB is pretty awesome.

  34. [video] Using SSIS with Azure SQL Managed Instance and Windows authentication by @pmpjr:
    youtu.be/HVpE_lpXBLI