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.

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.

• SSIS – Quickest way to add an existing SSIS Package to a Project
• SSIS – Update Properties of Multiple Tasks in One-Go
• SSIS – Define you own Keyboard Shortcuts in SSIS Package Designer
• SSIS – Ensure Consistency across Packages using Template Packages

Whitepaper – BI on Cloud using SQL Server on Windows Azure IaaS

In the previous blog post, we learnt the basics of cloud computing and how cloud computing and business intelligence are related to each other. In this whitepaper, I have covered the following aspects of Deploying a SQL Server Business Intelligence Solution to Cloud (Windows Azure) using IaaS (Virtual Machines) offering:

• Why BI applications should be hosted on cloud.
• What are the various cloud offerings,which can be used for hosting BI applications.
• Comparison of various cloud offerings and similar features on cloud IaaS (Virtual Machines).
• Step-by-Step procedure to host a simple SQL Server BI application on cloud.

To view and download this whitepaper, follow this link: BI on Cloud using SQL Server on IaaS.