Jan 28, 2019 | Custom Development, How To, JSON, Key2 Stories, Microsoft, SQL Server, SSIS, Tech Tips
By: Ken Adams JSON is a file format that has become more common for database professionals to encounter. Over the years, we have become accustomed to delimited text files, fixed length text files, Excel (I threw up in my mouth a little bit), and just as we got...
Aug 21, 2018 | Data Warehousing, How To, Key2 Stories, Microsoft, PowerShell, SQL Server, SSIS, Tech Tips, Technical Information
By: Ken Adams Introduction Disclaimer: Microsoft introduced the project deployment model for Integration Services (SSIS) over 6 years ago with SQL Server 2012. At this point in time, it is likely that you know a lot about project deployment. This post will...
Jun 14, 2018 | Key2 Stories, SharePoint, SQL Server, SSIS
By: Austin Gainey It’s always important as a SharePoint Administrator to try to understand what effect an update or upgrade to your system will have on the user base. Sometimes it’s easy, as SP admins, to get in the habit of simply hitting “next, next, Finish”...
Jun 5, 2018 | Fuzzy Logic, How To, Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Andy Kim I was at the SQL Saturday Atlanta conference last week and attended a session in which the speaker asked the audience, “Has anyone here used fuzzy grouping or fuzzy lookups in SSIS?” To my surprise, I was the only one who raised their hand....
May 8, 2018 | Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Matt Wollner Adding custom logging and auditing to your ETL process can be very beneficial – so much so that if your organization hasn’t added it to your ETL process yet, we highly recommend doing so. Many developers rely on SSIS to log their SSIS...
Feb 26, 2018 | Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Jharred Williams To kick things off, let’s start with a quick refresh on SQL Server Integration Services (SSIS) and what’s new with the tool today. To say SSIS is strictly a data extract, transformation and loading (ETL)...
