hypocrites

Yes, use the Foreach File Enumerator. Then, use the Expressions editor to set the FileSpec Expression to your expression from your first post. This will tell the enumerator...

You can use the For Each loop container to loop through a group of files. Set the For Each loop up so that it only considers files that meet...

Bubba.

Kit G (4/14/2010)

CirquedeSQLeil (4/14/2010)

So long as the upper 10% (income wise) do not get all of the same loopholes that continue...

Heh, I have to finish mine up tonight.

Well, in that case, you may have to open up the .dtsx file in Wordpad and search for the SCD task name. The file is stored as XML so...

grace

Use the Wizard to walk through the setup. Just keep in mind that if you get to the end of the wizard and select finish, it will rebuild all...

Well, this is a loaded question. The subject of performane monitoring and tuning is vast and detailed. I can give you some guidence as to where to start,...

It is possible, but it could get ugly in this scenario. The way SQL Server partitioning works, you would have to create procedures that manage your partition function and...

This is a duplicate post. Let's continue here in this thread.

For reference, the other thread is here.

I'm in agreeance with Paul here, why do you think you need partitions?

Duplicate post, continue thread here.

Creating procedures to manage partitions dynamically is not an easy task (I've done it). Since you are a self-admited SQL Server newbie, I'll start by asking the question, why...

As K Cline pointed out, put the update field comparison in the WHERE clause instead of the in a CASE statement in the UPDATE. This allows the optimizer to...