Ok, few weeks back I posted how to create a fixed width file using SSIS for test purposes. Then after…
SSIS
Exporting data from SQL Server to Fixed Position Flat file
Just as usual, this post is kind of “Bi-product” of my attempt to create a demo for another post in…
Logging in SSIS Package
Logging is an essential part of any application. It gives user an insight of application operation. And it proves valuable…
Using configuration file for SSIS package
SQL Server Integration Services (SSIS) are really nice ELT tool for data transformation, conversion and transfer. But they not of…
“Copy database” operation, quick ‘n easy way to make duplicate database
I was trying to create a demo for one of my experiment, and I had to make create duplicate database…
64 bit System and Debugging in SSIS
It has been always confusion between whether we should use 32bit OS or 64bit system… and in present time it…