RSS

Tag Archives: MSBI

SSIS – SQL Server Integration Services XML Configurations Tips and Tricks

Package Configurations are a very powerful feature of SQL Server Integration Services (SSIS). They enable us to handle various things dynamically at run-time.

In this tip, we will take a look at the following Tips and Tricks on SSIS XML Package Configurations:

  • Formatting the XML Configuration File for Improved Readability
  • Commenting Select Configurations in XML Configuration File
  • One XML Configuration File for Each Shared Connection Manager

To continue reading, catch the full article here: SQL Server Integration Services XML Configurations Tips and Tricks.

 

Tags: , , , , , , , ,

Big Data Basics – Part 2 – Overview of Big Data Architecture

In the previous post, we saw an Introduction to Big Data. In this post, let’s take a look at the following aspects of Big Data:

  • Architecture – Traditional vs. Modern (Next Generation Architecture) / Big Data Architecture
  • Few Big Data Use Cases
  • Reasons for Adoption of Big Data technologies

To continue reading, catch the full article here: Big Data Basics – Part 2 – Overview of Big Data Architecture.

 

Tags: , , , , , , , ,

SSIS – SQL Server Integration Services Connection Manager Tips and Tricks

Connection Managers and Package Configurations are among the most critical components of SQL Server Integration Services (SSIS) Packages. It is very essential to have a thorough understanding of these components while working with SSIS.

In this post, we will see following tips and tricks related to Connection Managers and Package Configurations:

  • Adding an “Application Name” property to the connection string
  • Creating Two Connection Managers for each Database Connection
  • Capturing Connection Manager details in Package Configurations

To continue reading, catch the full article here: SQL Server Integration Services Connection Manager Tips and Tricks.

 

Tags: , , , , , , , ,