Key2 Consulting
  • Home
  • Consulting Services
    • SOLUTIONS
      • Data Warehousing
      • Business Intelligence
    • SOLUTIONS BY TECHNOLOGY
      • Azure
      • Power BI
      • Azure Databricks
      • Azure Data Factory
      • Azure Data Lake
      • Azure Synapse Analytics
      • SQL Server
      • SQL Server Analysis Services (SSAS)
      • SQL Server Integration Services (SSIS)
      • SQL Server Reporting Services (SSRS)
    • SOLUTIONS BY INDUSTRY
      • Finance
      • Manufacturing
      • Pharmaceutical
      • Public Sector
      • Retail
  • Company
    • About
    • Careers
    • Our Team
    • Contact
  • Resources
    • Blog
    • Case Studies
    • SSIS eBook
    • Vlog
  • Contact
Select Page
Fun with JSON – A Customer Success Story

Fun with JSON – A Customer Success Story

Jan 28, 2019 | Custom Development, How To, 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...
How to Convert SSIS Package Deployment to Project Deployment

How to Convert SSIS Package Deployment to Project Deployment

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...
How to Deduplicate Data Using Fuzzy Logic in SSIS

How to Deduplicate Data Using Fuzzy Logic in SSIS

Jun 5, 2018 | 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....
Custom SSIS Logging and Auditing

Custom SSIS Logging and Auditing

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...
SSIS Performance Tuning Overview

SSIS Performance Tuning Overview

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)...

Recent Posts

  • 5 Key Takeaways From PASS Data Community Summit 2022
  • Migrating from Power BI Premium Per User (PPU) to Premium Capacity – What You Should Know
  • Power BI Import vs. DirectQuery – Which is Best for You?

Categories

  • .NET
  • Amazon
  • Amazon MWS
  • Amazon QuickSight
  • Analytics
  • Apache Airflow
  • Apache Spark
  • App design
  • Application Development
  • Artificial Intelligence
  • Azure
  • Azure Cosmos DB
  • Azure Data Factory
  • Azure Data Lake
  • Azure Databricks
  • Azure Machine Learning
  • Azure Synapse
  • Big Data
  • BIML
  • Business Intelligence
  • Careers
  • CCPA
  • Cloud Technology
  • Conferences
  • Consulting
  • COVID-19
  • Custom Development
  • Data Encryption
  • Data Governance
  • Data Management
  • Data Regulations
  • Data Security
  • Data Visualization
  • Data Warehousing
  • Databricks
  • Entrepreneurship
  • Fantasy Football
  • Featured
  • Featured
  • GDPR
  • GitHub
  • healthcare
  • How To
  • Key2 Stories
  • Machine Learning
  • Microsoft
  • Microsoft Excel
  • Microsoft Power Automate
  • Microsoft Power BI
  • Microsoft PowerApps
  • Open Source
  • PowerShell
  • RevoScaleR
  • Salesforce
  • Self-Service BI
  • SharePoint
  • Snowflake
  • Software Development
  • SQL Server
  • SSIS
  • Tableau
  • Tales from Consulting
  • Tech Tips
  • Technical Information
  • Uncategorized
  • Web 3.0
  • Web Applications
  • Web design
  • Web Development
  • What's Happening at Key2