Okay, you are storing the package at the file system - not in SQL Server itself. The command line looks okay - not sure what the problem is there.

What...

You are running Enterprise Edition (at least that's what it looks like). You can probably perform your index rebuild online using ALTER INDEX syntax. Look it up in...

You have to deploy the package to the server where Integration Services is running. You can do that several ways. My favorite is to save a copy of...

Great - glad you were able to get this to work....

I hear you - it is the same here also. I wasn't really trying to ruffle any feathers - I hope it didn't come across that way. 🙂

You can take SQL Server offline from cluster administrator. Once it is offline, on the same node that was hosting SQL Server - you can then start SQL Server...

From the maintenance cleanup task - click on the button to see the generated code and paste that here.

First, when using the task - you can either cleanup backup files,...

ALZDBA (10/26/2009)

---

Indianrock (10/26/2009)

---

SOLVED ! thanks for your input Gail, we will have to consider smaller inserts. I looked in our Spotlight tool and noticed the spid of...

I don't think that trying to determine how large the transaction log is going to get is going to work for you. It all comes down to the pattern...

G33kKahuna (10/25/2009)

---

Is there a way to estimate the transaction log growth in different recovery models? We know the OLTP daily estimates, but so far are unsuccesssful in correlating the file...

Jeff Moden (10/23/2009)

---

Not a challenge here, Jeff... I really don't know and would like to find out. Are you saying that if I want to retire a 32 bit...

Not sure about quicker - but you could always setup a linked server. How you connect to Informix is dependent upon what is available for that system.

Oh - I agree and my preference is to do stuff like this after hours regardless. If you have a very good SAN team who has lots of experience...

CirquedeSQLeil (10/23/2009)

---

based on experience, we have had the SAN occasionally decide that it was going to consume too many resources to resize the disk - and occasionally it has rebooted....

The owner of the job is not the user that is...