Tag Archives: SSIS

Upcoming Events

I’ve signed up for a few more SQL Saturdays and I’m very excited about both.  The first I will be speaking at is SQL Saturday #89 in Atlanta, GA on 17 September 2011.  One of the reasons I’m excited about … Continue reading

Posted in SQL, SSIS, Travel | Tagged , , | Leave a comment

SSIS Quick Tip: Treating code like code–Comments

Developing an SSIS package means that you are writing code.  Developing a T-SQL Select statement, stored procedure, function, table or other construct means that you are writing code.  Developing an SSAS cube or SSRS report means that you are writing … Continue reading

Posted in SSIS | Tagged , | 2 Comments

SSIS Quick Tip: Size Matters

I imagine that other people have some of the same issues with enterprise data models which I have had in the past.  It seems that no one wants to be the person who might limit someone’s artistic abilities to write … Continue reading

Posted in SQL, SSIS | Tagged , | 3 Comments

SSIS Quick Tip: Data Conversion Transformation or Cast in Source?

After having a great conversation tonight at the JSSUG meeting, I am once again reminded of the time I spent learning SSIS.  There are lots of subtleties and nuances that, if you’re not careful, will lead to poor performance.  As … Continue reading

Posted in SSIS | Tagged , | 1 Comment

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

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

SSIS – Retain Values from Previous Rows

There are times when data is read in a fashion that needs to be examined and compared based on the value(s) of the previous record(s) for a particular grouping.  For example, one might have the following data which does not … Continue reading

Posted in SSIS | Tagged , | 2 Comments

ODS Indexes, when should we trash them?

It is said that a fair majority of the ETL process is spent dealing with indexes.  So, how can we decide when to destroy an index and then recreate it after the table is loaded?  Do you maintain these indexes … Continue reading

Posted in SSIS | Tagged , | Leave a comment

Small Tip for Impact Analysis

I’ll confess, our shop is not the most organized in the world.  We are still working on certain items that I would hope most shops have long ago put in place as part of their standard development cycle.  Items such … 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