Blog Archives

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…

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…

This is a great introduction video for Async Programming in .net 4.5 making multi threaded application super easy and bug free. In below tutorial You will learn following concepts Using Task Using Async and Await Keywords in .net 4.5

I just came across need where I wanted to shuffle my dictionary with random order. Here is code snippet which uses Linq to randomize order of key/value pair you added. using System; using System.Linq; namespace MyApp { public class MyClass…

In this post I want to share snippet which shows simple technique to implement multiple transformations on same object. You will notice that in order to achieve this I have used TransformationGroup along with StoryBoard and DoubleAnimation private void Rotate_Click(object…

Have you ever got this error “File is being used by another process” Just try this create simple textfile on disk (e.g. mydata.txt) and open it with Excel… This way its locked (This is my trick to mimic locking of file) Now try…

This code snippet will make your life super easy if you have similar need what I had. Here is simple problem… If you have DataTable(s) or You have DataSet with Multiple DataTables and You want to Insert all records to…

I get this question many times. And this question starts religious war… My language is better than yours !!! Lets not get into what language is better than other. Lets talk whats the strategy Microsoft’s Compiler Services division heading towards Microsoft…