I have already begun using the new SSIS Project Deployment Model where I am able. I did not know it was coming, but I have wished that SSIS deployment could work this way for a long, long time. …this brief introduction into the capabilities of Project Deployment Model should give … Continue reading →
My migration to SQL Server 2012 has actually been going rather smoothly. The other issues apart from the one I discussed earlier have been relatively minor, although some were time consuming to work out and some were annoying. Here is what I have run into so far:
Continue reading →My SSIS Batch Geocoder for SSIS 2008 R2 is now available on Codeplex. It’s a free SSIS Data Flow component that converts address data to latitude and longitude. This can be very useful when using the Map features of SSRS 2008 R2.
Continue reading →This last week I wrote two SSIS packages (SQL Server 2005) that read data that was originally published using Excel .xls format and populated a staging table. The data is only published once a year, with perhaps one or two corrections following, but I thought I would save a little … Continue reading →
