Most of the companies use some sort of unique format for their reports and this layout is kept same for all of their reports to create some sort of identity or brand. And for that developers usually use some kind of template to create default layout of report, and most of all reporting systems supports
Tag: How To
FTP connection using BATCH file
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
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