SSIS does not provide this functionality and I have seen no plans to introduce it.

You mention sourcesafe, I'll enlarge that to any SC system, I have used VSS and TFS...

I believe Professional Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer) talks about it in a later chapter, that is where I got enough information to build my...

I don't think your upgrade path will work as described. As I read it you are doing a version upgrade of an existing instance on the passive node then...

SQLRNNR (11/23/2011)

---

I probably am in...

Depending on what you need you could look at the SQLCLR at:

http://nclsqlclrfile.codeplex.com/%5B/url%5D

CEWII

Then build a process to detect what data you do have and back out the references to data you don't. The position that there is NO way around this...

Just because you can lose 24 hours worth of data doesn't mean you have to. I would seriously rethink this requirement that the databases and app data have to...

Generally I agree with...

Perry Whittle (11/22/2011)

---

Elliott Whitlow (11/22/2011)

---

If my quorum becomes unavailable the whole SAN is just as likely unavailable too and it doesn't matter if the cluster is running because my SQL...

Depends on the topic.. If you want to do something monumentally boneheaded in SQL then I'm going with No, VERY difficult..

CEWII

I've seen some issues if you are not a domain admin getting the SQL Virtual name to come online correctly. But I use a domain account (required) with only...

No problem, it could have been the way I read it as well.

Simplest answer 1 SSMS per SQL Version Installed regardless of the number of instances.

CEWII

I generally agree. I have not had cases where I felt clustering the DTC was advantageous, YMMV. As far as Quorum this is a little less clear, you...

Yes, it can be used by multiple parents.

Please see:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70346/%5B/url%5D

and

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70347/%5B/url%5D

CEWII

corbett (11/21/2011)

---

Perry, many thanks for your input.

It's going to be a 2 node cluster, active/passive. So the quorum has no performance impact on the drives? I read some other...