Category 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

SQL Saturday #74 Recap and SQL Rally

Only one post this week as I am extremely busy at the moment.  I’ll do a quick recap SQL Saturday #74 and give some exciting news.  Unfortunately, my camera died sometime right before lunch.  Oh well: First up, the quick … Continue reading

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

SQL Saturday #74 Jacksonville, FL

SSIS Data Flow Buffer Breakdown I just wanted to once again try to get the word out about the SQL Saturday conference this weekend in Jacksonville, FL.  My Derby hat will be doing a presentation on SSIS Data Flow Buffer … Continue reading

Posted in SQL, 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