Great comments!

Rainer: Deleted rows can be correlated with a Right Join instead of a Left Join, and Filtered the same as New Rows. For the Delete action...

There's the potential for a slippery slope here, but I think Karma nailed the solution - black box testing is good enough for pharma regulators, it should be good enough...

Excellent points Dave.

I think Drucker said something like "Management is doing things right. Leadership is doing the right things."

And thanks for serving.

:{> Andy

Good stuff Steve.

I believe there are two types of managers: those who say "Follow Me!" and those who say "Go Do That!" I consider the first type Leaders because, well,...

Good editorial Steve. I couldn't agree more: Leadership is the issue.

I believe an organization has to be ready for IT leadership - just like it has to be ready for...

How many of you have actually asked for requirements for a project, been given some, and then all of a sudden new requirements come up while you're in the middle...

Thanks Matt!

I don't use DTS (or competing products) enough these days to speak about how SSIS performs when compared to them. I can tell you:

1. In general...

Steve: Your nuclear power plant experience reminds me of when I received a security clearance. 🙂

Arthur: I dislike government intrusion more than you can know. But "10 minutes before your...

Great editorial Steve!

I saw what I interpretted as a push by Microsoft to move into Oracle and DB2 shops with per-socket and multiple-instances-per-seat* licensing over the past...

Great topic Steve!

The Richmond Virginia Developer Community suffered when a charismatic leader got too busy with other things. Since then, the leadership has worked hard to put...

Hi Kreecha,

Is it possible to have SSIS monitor data in tables that are renamed or created? The answer is "Yes". Is it optimal, no.

...

Hi Fillipo,

I'm confused by the "by wizard" phrase. Do you mean you want to automate extraction to XML?

Andy

Hi Jassmeet,

As with a lot of SQL Server-related questions, the answer is (once again) "it depends". 🙂

Here's a list of things you get with...

Hi Vinod,

There is another way: in the Execute SQL Task there's a property called SQLSourceType. By default it's set to "Direct input" but contains the options "Variable"...

Hi Peter,

Try this: Remove the ConnectionString expression from the File System Task. Edit the properties of the @[User::MyDestFile] variable. Set the EvaluateAsExprerssion property to True and enter...