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

Video Tutorial – Asynchronous Programming in .NET 4.5 (Task, async and await) – C# 5.0


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

Tagged with: , ,
Posted in .net, C#,

How to randomize sort order in dictionary using Linq


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

Tagged with: ,
Posted in .net, C#, Linq

XAML Animation – How to Scale and Rotate Object (Multiple Transformations)


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

Tagged with: , ,
Posted in .net, C#, XAML

How to Read Locked file in VB or C#

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

Tagged with: ,
Posted in .net, C#,

Bulk Load DataTable to SQL Server Table

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

Tagged with: , , , , ,
Posted in .net, SQL Server or C# – Which language should you pick for future

Zemanta Related Posts Thumbnail

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

Tagged with: , ,
Posted in .net