Thanks to everyone for taking a minute to help me on this SSIS issue.

I'm trying very hard to like SISS but it feels very muc like SSIS doesn't want...

GSquared (4/6/2010)

---

Set up either a script or job that the IT people need to run before they do a shutdown. Maybe a simple VB.NET Windows app with a "pre-shutdown...

Paul White NZ (4/6/2010)

---

YSLGuru (4/6/2010)

---

If I have an Index that over a full cycle, has a large value under the User_Updates columns but has a value of 0 for all...

At this point I'm goingto assume everyone is just as uncertain about where SSMS keeps its config info as I am. While it doesn't suprose me that no...

I'm confused by your question, did you post this tothe wrong thread perhaps?...

Grant Fritchey (4/6/2010)

---

YSLGuru (4/6/2010)

---

Does anyone know where in BOL or somehwre else like MSDN, one can find detailed explinations on the 4 various metrics tracked by SYS.DM_DB_INDEX_USAGE_STATS , specifically the...

GSquared (4/6/2010)

---

Um, this may be a stupid question, but is your server suddenly shutting down spontaneously on a regular basis?

If I need something to run before the server shuts down,...

After some mroe digging aorund I believe the official answer to this question is NO. I dont; even see where this has changed in 2008 and I'm betting its...

Grant Fritchey (4/6/2010)

---

For the period you're covering, the answer is yes. That still doesn't say that the day before you started or the day after you stop, some query won't...

Jeff - I just read over this thread and was curious if there was...

Thanks. I knwo your as busy as the rest of...

cfradenburg (3/26/2010)

---

There are a few ways to do this. You can create a table that has a list of indexes used each day (remove the check for null stats...

divyanth (3/29/2010)

---

you add the ForEach Loop to the package do you drag it on to the work area and then drop the connection inside of the loop or do...

Wow, lots of replies and quick on this one. Thanks.

In our case the drive space is definately not an issue adn when I make this change I will leave...

divyanth (3/26/2010)

---

I looked at the example you referenced and downloaded the sample file the author provided but its still not clear. What I rally need is an on line...