Viewing 15 posts - 631 through 645 (of 3,232 total)
This numbering system generated from a stored procedure provides all types of information at a glance as well as provides a unique ID used in other tables.
I can see instances...
March 15, 2010 at 3:41 pm
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...
March 15, 2010 at 3:29 pm
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...
March 15, 2010 at 12:15 pm
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.
March 15, 2010 at 11:41 am
Use a date column from your table in the WHERE clause to limit the # of days you want to bring back.
March 15, 2010 at 10:19 am
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...
March 1, 2010 at 11:25 am
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...
February 24, 2010 at 9:54 am
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. ...
February 22, 2010 at 11:20 am
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...
February 22, 2010 at 11:06 am
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...
February 20, 2010 at 4:53 pm
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...
February 19, 2010 at 3:39 pm
You'd have to check with your SAN administrator.
February 19, 2010 at 3:29 pm
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...
February 19, 2010 at 3:13 pm
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...
February 19, 2010 at 2:51 pm
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...
February 19, 2010 at 2:23 pm
Viewing 15 posts - 631 through 645 (of 3,232 total)