Blog Archives

Reference Assembly in SSIS Script Task (.net Custom Assembly)

In this blog post I want to show how to reference custom .net Assembly in SSIS Script Task. Assume you want to use some JSON dll in your Script Task instead of this json connector. Here are the steps. Add

Tagged with: , ,
Posted in SSIS

Get File Column Count using SSIS C# Script Task

Sometimes you have changing schema in your flat file (Columns added or Removed) If you ever want to know how many columns you have in flat file then simply use below snippet and it will tell you column count. #region

Tagged with: , , ,
Posted in SSIS

How to use SSIS Data Viewer in DataFlow Task

SSIS Data Viewer - Debug Pipeline

In this post you will learn how to use SSIS Data Viewer to debug/troubleshoot SSIS DataFlow Pipeline issues at runtime. You can use SSIS Data Viewer any time you want to see what your data look like at given point

Tagged with: , ,
Posted in SSIS

How to use SSIS Derived Column Transform

SSIS Derived Column Transform Expression

What is SSIS Derived Column Transform SSIS Derived column transform is used to change existing columns coming from Source or add New Columns in the Pipeline Buffer. Note: For simplicity we have used Free DummyData Generator Source in this post

Tagged with: , ,
Posted in SSIS

ETL World Record – 1 TB data load in 30 Mins with SSIS

ssis-logo

Here is great white paper from TechNet Microsoft which describes what techniques Microsoft used to achieve 1 Terabyte data load in just 30 Mins using high performance data load techniques in SSIS. Link: ETL world Record – 1 TB Dataload

Tagged with:
Posted in Business Intelligence, SSIS

SSIS Best Practices for high performance – suggested by microsoft team

ssis-logo

Here is a great presentation from Microsoft Team. This document describes how to get high performance by following some SSIS Best Practices ****** Please wait for few seconds before below presentation loads !!! ***********

Tagged with: , ,
Posted in Business Intelligence, SSIS