Blog Archives

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