There are a couple of different ways you can do this. Most likely the easiest way is to send the incoming data to a Conditional Split transformation, and use...

When building a package that allows the user the option of specifying a value for a date variable, I'll set the value of that variable to something unusual, such as...

I know it's a basic question, but are the services set to automatically start?

When you start them manually, do they keep running or do they stop shortly after?...

You certainly could use temp tables (though if you take that approach, I recommend using permanent staging tables to avoid potential issues with temp tables). However, if this all-or-nothing...

Agreed that the simplest way is to use a conditional split if possible. However, if your footer record(s) is not structured like your other rows, it's possible that you...

That was quite a shot that McCarthy took to the head last night. Scary stuff.

Hard to believe. I assumed that Ichiro would die a Mariner. I've always enjoyed watching him play,...

Prince Fielder looked good last night. I was surprised at the vitriol from the crowd toward Robinson Cano. Is it just him, or do they just really hate...

Same here, but tired for a different reason. I went to the Rangers game last night and watched our boys get shelled at home by the Mariners. Down...

Agreed. He's worn out my Rangers over the years, but I hate to see his career end with a whimper like that. Hopefully for him, he's got one...

Damn.... Mariano Rivera went down with a torn ACL while warming up catching fly balls during batting practice.

http://mlb.mlb.com/news/article.jsp?ymd=20120503&content_id=30328258&vkey=news_mlb&c_id=mlb

At 42 years old, you've got to wonder if he'll make it back...

I think we'll start to hear the drum beat louder from the instant replay advocates after this ridiculous call last night:

http://sports.yahoo.com/blogs/mlb-big-league-stew/tim-welke-makes-one-worst-calls-ve-ever-235447642.html

The still images don't tell the whole story; the video...

For you fiction readers out there, I highly recommend Calico Joe (http://www.amazon.com/Calico-Joe-John-Grisham/dp/0385536070). It's a fictional account of a couple of baseball players from back in the 70s. A...

Friday night was an emotional night here in Dallas, but not nearly as much as Thursday. One strike away - twice. There was definitely a momentum shift on...

No doubt, Verlander is the linchpin. I've said all along that I'd rather face the Yankees and all that brings with it rather than seeing Verlander. They'd almost...