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
How to Leverage Biml to Automate SSIS Package Development

How to Leverage Biml to Automate SSIS Package Development

Jan 29, 2020 | BIML, Business Intelligence, Microsoft, SSIS

By: Andy Kim   What is Biml? Business Intelligence Markup Language (Biml) is an XML-based language that can generate (SQL Server Integration Services) SSIS packages, amongst other things. The programming language was developed by Scott Currie and his company...
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...
Testing Changes in SharePoint 2013 Enterprise Farm with SSRS Report Builder 2016

Testing Changes in SharePoint 2013 Enterprise Farm with SSRS Report Builder 2016

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”...
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...
« Older Entries

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