#ssis — Public Fediverse posts

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)

https://www.sqlfingers.com/2026/03/ssis-is-not-dead-yet.html

#SQLServer
#SSIS
#ETL

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 https://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

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

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

https://habr.com/ru/articles/927416/

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

Announcing SQL Server 2025 Public Preview | by Bob Ward.

https://www.linkedin.com/pulse/announcing-sql-server-2025-public-preview-bob-ward-4rz2c/

#sqlserver #database #data #sqlserver2025 #linux #ssms #ssis

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

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

How to Fix the #SSIS Error 'Cannot Convert Between Unicode and Non-Unicode Strings' #SQLServer #SQL

https://improveandrepeat.com/2024/10/how-to-fix-the-ssis-error-cannot-convert-between-unicode-and-non-unicode-strings/

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.

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.

Speaking at #DataSaturday Rheinland – Migrating #SSIS to #Azure Data Factory cc @datasaturdays https://sqlkover.com/speaking-at-data-saturday-rheinland-migrating-ssis-to-adf/

My blog post on installing #SSIS 2022 is the most popular one for the last 30 days. Even more popular than my utc datatime post 🤯
For people wondering if #SSIS is dead...

Dear SQL Server, while you can move away from #SSIS all you want in favor of Azure flavoured things, please don't crush my retirement dreams of being the emergency consultant who knows way too much about it (and charges for it) https://stackoverflow.com/a/74787356/181965

Never use #ssis when #bcp will work. #sqlserver

New blog post: User Group Meeting – Migrate your #SSIS skills to #ADF & More #Azure #CosmosDB https://sqlkover.com/user-group-meeting-migrate-your-ssis-skills-to-adf-more/ > next Monday, hope to see you there!

New blog post: How to Install Integration Services 2022 https://sqlkover.com/how-to-install-integration-services-2022/ #SSIS #sqlserver2022

When it comes to the BI & data visualization change what I'm liking the most is the technical challenge to extract insights. Working with #SQL, #Python, #Pandas, #Excel, #SSMS, #SSIS, #SSAS, doing #ETL... It aint easy but it is rewarding. Also learning a lot using #Tableau, #Qlikview and #Talend.

Hardest and least appealing to work with so far has been #SSRS, but I like the results when I manage to get what I want :)

My current employer is using #activemq along with #oracle databases and #oracle #WebLogic_Server as a service-oriented architecture (SOA) to create data interchange amongst disparate systems. It is mostly performing extract-transform-load #etl operations. I wrote something in #python which is way more lightweight and does the same. However, it is more of a script and not necessarily a solution.

What would you recommend as a replacement for the SOA architecture? #ssis? #mulesoft? #camel?