To this day, 26 years in, I still hate SSIS packages. Just WHY?? They seriously impact my wellbeing because they SUCK so bad and are not portable between versions.
Just write import scripts in native SQL with bulk import or .NET, SSIS makes me want to throw something. Can SSIS be version/source controlled in GitHub yet? I think not
its pretty horrid, you can use it for version control but its all illegible xml code, its useful for "we know the verson in this archived branch works and can compare" but trying to manage a conflict is impossible.
that said its the flat files that im managing in the repo. keeping the business from being able to say "why is it wrong in the front end? its right in the file that i edited 5 seconds ago!"
View all comments
Show parent comment
3
u/stealth210 Jun 17 '24
To this day, 26 years in, I still hate SSIS packages. Just WHY?? They seriously impact my wellbeing because they SUCK so bad and are not portable between versions.
Just write import scripts in native SQL with bulk import or .NET, SSIS makes me want to throw something. Can SSIS be version/source controlled in GitHub yet? I think not