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