I can see instances...

It would depend on how you've indexed your tables. I would prefer to use the lookup transformation against an indexed column. If all you need to do is...

Please see the article in my signature line and post an example of what you are looking for. This sounds easy enough, but we need to clearly understand what...

No, creating a FK does not create an index on the same column(s). If you want an index on your FK column(s), you must explicitly create it.

Use a date column from your table in the WHERE clause to limit the # of days you want to bring back.

I ended up purchasing an additional 2 TB of disk space for our SAN. In fact, the SAN that we were using was almost full so I had to...

Speaking of the Olympics, did you hear that they're going to pull the gold medal away from the woman's downhill skier?

They've decided to give it to Obama instead because it...

Well, like I said, use an ExecuteSQL task prior to your Data Flow. Have that task query get your start/end date parameters and place them inside package variables. ...

You could set up an Execute SQL task that runs prior to the data flow that gets the start/end date values and populates package level variables.

Just curious, why...

I agree. That does not sound right. Either your Z:\ drive is not a RAID 10 (and is in fact a RAID 0 - no RAID) or it...

I can't put together a package for you now as I'm leaving for the day, but at a high level, here's one way to do it.

1. You'll need a task...

You'd have to check with your SAN administrator.

So are you having a specific problem with implementing this or do you just want some general how-to's?

So, do all of your table have a date column that you can...

So your Z drive is where your backup files are being written. It is a RAID 10, but how many disks? You may just need to adjust your...

It depends on how you've laid you files out on your disks. The disk alert references disk Z. What is on Z? Also, keep in mind that...