One of my recent project requirements has prompted me to write this blog. The project requires generating various reports for client using SQL Reporting services tool in PDF format. We created the required reports in PDF format using SSRS and…
DTExec issues running ssis packages in 64 bit
Couple of days before, I was working on an SSIS package doing importing of some data from Excel spreadsheet to a table in SQL database. I built the package and tested it locally successfully. The intention was to create a…
Simulating file watcher task in ssis
A typical scenario encountered in file processing systems is implementation of file watcher module which polls a particular folder for availability of file and once available it does some processing with it. Unfortunately there’s no standard task that’s shipped with…
Simple sql code deployment utility
I’d to do code deployment of sql scripts to production server from my development server for one of my projects recently. The project had a large number of sql scripts which had to be deployed to live server. For easy…
why iso format is recommended while passing date values?
The reason for posting is because there have been at least a dozen times when I’ve come across posts from others stating problems in passing datetime values to sql query. Mostly this happens when the date values are being passed…