Hi Corné,

In this series, we are using Microsoft SQL Server 2008 R2 Business Intelligence Development Studio. In the very first article in the series, I cover where...

Hi SQL Oracle,

In the Control Flow toolbox, there is a group labeled Maintenance Plan Tasks beneath the Control Flow Items group.

Hope this helps,

Andy

Interesting editorial and good points, Steve. It will be interesting to follow the economics of data gravity as the barriers (costs) to moving decline. Will we see a "haven" of...

The OLE DB Source allows you to write a SELECT statement to only pull the columns you desire. I recommend always writing such a statement.

Hope this helps,

Andy

Samuel Vella (11/25/2011)

Hi Thomas

A quick dig round my registry uncovered this:

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\Packages\{4a0c6509-bf90-43da-abee-0aba3a8527f1}\Settings\Data\Connections

Which contained a list of all...

I'm CSO (Chief Servant Officer).

:{>

Hi Thomas,

I honestly don't know where the connections metadata is specifically stored, and I cannot recall who told me it was stored in the Users' profile. :\

Hi rrn 62873,

Thank you for your kind words.

You will find some outdated SSIS advice that recommends using the SQL Server Destination instead of the...

Hi Erin,

You are correct - my intent was to delete the rows from the Destination table (dbo.Contact), not the source (Person.Contact).

Good catch and my...

Hi David,

You are correct, but I do not plan to cover the Merge statement in this series.

Andy

Thanks Everyone!

Half the credit (minimum) goes to The Best Editor On The Planet: Steve Jones.

:{>

Hi Ravi,

I'm traveling today and find it difficult to type or paste links from my phone. I'm old school. And old. If you browse to SQLblog.com and...

Hi JJ,

I have an excellent editor, Steve Jones.

:{>

Thanks Stephane,

There is a way to create audit trails of record states, but that topicis beyond the scope of this series. I can get you started offline....

Hi NYSystemAnalyst,

That's a poorly-worded sentence. My apologies. The No Match output exists in 2008 and R2.

:{>