Tag Archives: Rant

Slight SSIS Rant, Or, how I grew to hate the transfer sql server objects task

SQL Transfer So, as most people who would be reading this blog know, I am a pretty big fan of SSIS.  There are, however, some serious limitations to the product that still exist.  One of these deficiencies came back to … Continue reading

Posted in SSIS | Tagged , | Leave a comment

Reconciliation

Over the past few weeks I have been fighting with what I would have at first thought to be a fairly straight forward task.  I was to add a few breakouts for some financial information that would provide the data … Continue reading

Posted in Data Warehousing | Tagged , | Leave a comment

Maintainability / Readability of SSIS Packages and Jobs

This past week has held many issues with a recently released application under the purview of the DBA team.  What has really separated this from a host of other jobs and procedures which they watch over is that this application … Continue reading

Posted in SSIS | Tagged , | Leave a comment

Microsoft Ole DB Provider for DB2: The Evil Bang!

Just a quick note from earlier in the week.  After successfully using the Microsoft OLE DB Provider for DB2 for many many MANY packages in the past to communicate with our DB2 servers on various platforms we had a problem … Continue reading

Posted in SSIS | Tagged , , | Leave a comment