Cozy,

I think that is only true for custom SSIS components.

CEWII

Super, I figured it wasn't corruption..

CEWII

CirquedeSQLeil (5/6/2010)

---

You need to know what servers are "Production"

Non production development servers don't need to be licensed. Thus knowing what servers are serving up production data and apps will...

I think you have what I would call an order of operations problem.

When you change a connection or pass in a modified variable value it is set at the start...

You need to keep in mind that there is a lot of additional memory needed to support this. Those drives do have updated drivers that cuts the amountof memory...

I agree with Dan, SSIS supports Excel source and destinations out of the box without additional components.

CEWII

I don't think there is a good way.

However, to know how many you need to true up is pretty easy. You need to find out what you have licensed...

I agree, this feels like either a DNS problem or a connectivity problem..

CEWII

I have never seen any such thing happen..

1. Get a current backup

2. Either setup a trace or setup a DDL trigger to see what is actuallybeing issued to the database....

Sorry, that doesn't tell me much..

How about the errorlog?

CEWII

Does the SQL errorlog show anything?

Does the system or application eventlog show anything?

CEWII

First, I think there is some confusion. For a two node cluster it is either Active/Active or Active/Passive, your reference is confusing.

You tried to move it from one node to...

That is good to know..

CEWII

I guess my thought is that it might be nice to know but if you truly do have the licenses for them then in the end it really doesn't matter...

I have to admit I would spend some time and re-architect the whole drive layout. You could reduce the number of drives used from 18 (that is what is...