• Data Platforms
    • Databricks
    • Microsoft Azure
    • Microsoft Fabric
    • Power BI
    • SQL Server
  • Data Engineering
    • Azure Databricks
    • Azure Data Factory
    • Azure Data Lake
    • Azure SQL DB
    • Azure Synapse Analytics
    • SQL Server Analysis Services
    • SQL Server Integration Services
    • SQL Server Reporting Services
  • Company
    • Microsoft Fabric Workshop
    • About
    • Blog
    • Careers
    • Industries
      • Finance
      • Healthcare
      • Manufacturing
      • Pharmaceutical
      • Retail
      • Public Sector
    • Our Team
    • Resources
      • Azure Resources
      • Case Studies
      • Power BI Demo
      • Power BI Resources
      • SSIS eBook
  • Contact Us
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, 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, 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 | 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

  • Key2 Consulting Partners With Databricks To Help Companies Maximize Data and AI
  • How to Build Metadata-Driven Pipelines in Microsoft Fabric
  • Getting Started With Copilot in Microsoft Fabric

Categories

  • .NET
  • Amazon
  • Amazon MWS
  • Amazon QuickSight
  • App design
  • Application Development
  • Artificial Intelligence
  • Azure
  • Azure Cosmos DB
  • Azure Data Factory
  • Azure Databricks
  • 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
  • Key2 Stories
  • Machine Learning
  • Microsoft
  • Microsoft Copilot
  • Microsoft Excel
  • Microsoft Fabric
  • 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
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site, you consent to our use of cookies and the terms of our Privacy Policy.Got It!