How to call a SSIS package from .NET application

Problem You have a SSIS package and a .NET application allows your end-users whenever they determine to transfer data from server A to server B in your system. Solution One of approaches, Iwill use .NET framework to develop our application to call a SSIS package system file(.dtsx) . In this article, I'm developing .NET application … Continue reading How to call a SSIS package from .NET application

How to load data with Web Service Task and XML Task in SSIS

Problem I need to retrieve data from my partner system but they do not allow to access the system directly. Instead they provide me some Web Services to retrieve data what I need. Solution One of approaches is we use Web Service Task and XML Task components in SSIS. In this article, I'm going to demonstrate … Continue reading How to load data with Web Service Task and XML Task in SSIS

How to create a template package in SSIS

Problem  You have multiple data sources (csv, txt,..). They have different formats and but they have same business logic in transformation stage. For example: all of your files have the same fomulars : If ProductCode is Empty, it is converted to (Unspecifiled) Total Amount = Price x Quantity - Discount Amount Now, you must implement SSIS packages … Continue reading How to create a template package in SSIS

Data-warehouse concepts in Kimball approach

Introduction In previous article, I compared two approaches in designing data-warehouse, Inmon and Kimball. Today, I would like to go some basic concepts in Kimball approach. What kind of dimension tables? What kind of fact tables? And how are hierarchies? To make it simple and easy to understand. I have drawn the image "A picture is worth … Continue reading Data-warehouse concepts in Kimball approach

TSQL: Working with LAG() and LEAD() functions

Problem Have you ever developed reports for tracking Year Over Year(YOY) Sales by Category from a OLTP database in SQL Server or something likes that? To prior SQL Server 2012, it's quite complicated for you to build T-SQL script to query data for these reports. Maybe, you must build many sub-queries to do that. However, Microsoft … Continue reading TSQL: Working with LAG() and LEAD() functions

TSQL: ANSI_WARNING and ANSI_NULL with Store Procedure

Problem Have you ever considered how ANSI_WARNINGS and ANSI_NULL affects your store procedure? In this article, I'm going to explain which differences when we use those options with a store procedure and an ad-hoc query. ANSI_WARNINGS Definition ANSI_WARNINGS control ISO behavior various error conditions. It raises a warning error if it is ON following up several below … Continue reading TSQL: ANSI_WARNING and ANSI_NULL with Store Procedure