We have all run into a need or a desire to clean up old stale files from the file system, whether it be to remove old backup files or flat files that are created from one process or another. And based on this need/desire, we have all come up with a method to help with achieve that goal.
Every now and again I find myself working with SSIS for one reason or another. Every now and again I find myself fighting with SSIS because it provides less than useful error messages. This is […]
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality is, not all of those uses are good for you nor for your data nor […]
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those cases where you are consulting or you have taken on a new job. Suppose you […]
Pro-tip on how to quickly and easily migrate data sources for reporting services.
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found myself in need of extracting all RDLs from a Report Server on more than one […]
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan. That evolved into finding out who owns the the job associated with the maintenance plan. […]
Have you ever needed to export different data sets to different flat files? Each of these data sets could be customer information for different clients – but they all require the same fields. I have […]
While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time as parts of release cycles), I ran into self-imposed requirement. I was attempting to create […]
Not too many moons ago I embarked on porting some servers over from SQL 2000 to SQL 2008. On some of these SQL 2000 servers, we had numerous DTS packages performing various ETL functions. One […]