Lynn Pettis (9/2/2010)

---

Looks like I've missed something on forums the past couple of days. I've been fighting a cold/allergies plus the new job, just haven't been on as much...

Jason, you can keep an eye on that 2005 upgrade if you want. I'm running for cover.

Would you let someone who's not sure how to install SQL 2005 do...

Before going any further, are you installing this on the same server as your SQL 2000 instance? Have you backed up everything? Once it starts upgrading SQL 2000...

Waders

Lynn Pettis (9/2/2010)

---

Alvin Ramard (9/2/2010)

---

CirquedeSQLeil (9/2/2010)

---

jcrawf02 (9/2/2010)

---

Tom.Thomson (9/2/2010)

---

Surely you don't expect all the posts...

CirquedeSQLeil (9/2/2010)

---

jcrawf02 (9/2/2010)

---

Is this...

I think you need to take a look at the DTExec statement and look at how you can use it to pass parameters.

Been there, done that.

I...

Rats, your partial post plus mine totalled up to a full post!! 😛

Here's the partial post.

Lynn, why don't you

😀

Make that 25.3/day

DECLARE @PostCount AS INT

SET @PostCount = 18052

SELECT CONVERT(NUMERIC(5,1), (20000.0 - @PostCount)/ DATEDIFF(DAY, GETDATE(), '2010-11-18'))

I must have been more tired than I thought when I first answered this one.

FYI, we need approximately 25.4 posts per day to hit 20,000 by Nov 18th.

Instead of passing the database name to the package, would it be acceptable to have the first step in the package read that value from the database?

WILLIAM MITCHELL (9/2/2010)

---

Just an idea, but you could use SSIS just to prep the data into staging table(s) and then use SSRS to create a formatted report & create a...