I really love DOS commands. They are so powerful and yet simple (most of the time). Few days back I was required to create a script to download files from FTP site to local folder, and this has to be done at scheduled time. I decided to use my all time favorite script language to
Category: How To
Logging in SSIS Package
Logging is an essential part of any application. It gives user an insight of application operation. And it proves valuable in event of any issue. Same stands true for SSIS packages as well. Since SSIS package will get executed usually by SQL Server Agent or some Windows Scheduled Task and in both case it is
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 much use if they can’t be configured to accept different parameters. For example, a once task to move file is designed if it can’t be used to look for file in different folder or FTP
Setting up personal Source Control Server using Visual SVN Server
I was working on one of my personal projects and I thought that it would be really cool if I have my own source control mechanism so I can always rollback to older versions if I ever need to do it. Till now, I was always just keep multiple copies of each project so if
Becoming administrator of my own machine !!
I know, it sounds strange. But it is fact that when we install Windows 7 or Vista (say any non-server post XP OS ?), and even if select ourselves as local administrator we actually don’t become administrator !! And due to that even if you disable that notorious UAC notifications you will still sometimes need
Removing Favorite, HomeGroup and Libraries from Explorer in Windows 7
I like Windows 7. No doubt that it is better than Windows Vista at few aspects (but still XP was the best , I really miss search of XP). With new UI, Windows 7 has add new options in Windows Explorer like Favorites, HomeGroup and Libraries. But I personally believe that they are just a
“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 for that purpose because I didn’t wanted to do tests on my TestDB so quickest option was to use “Copy Database” feature in SSMS, because other option like restoring backup of DB with another name