You are very welcome, I hope it gets to working for you.

CEWII

I wouldn't apply these constraints in the table themselves, the main reason is that the data would need to be in clear-text and that is wholly unacceptable for a password...

zachsteve77 (12/7/2009)

---

So if I have this right I need to create a credential and a proxy on the server that is running the package that matches up to a login...

kiransuram19 (12/7/2009)

---

>> Yes. Server C has SQl server 2005 on windows 2003.

-Server C can talk to both A and B .

-A and B were able to talk to C....

Definitely test it! The key to getting them to failover together is they need to be in the same resource group, I don't believe resource groups can be linked...

ALTER VIEW is kind of like a drop and rebuild in that you have to specify the whole SELECT statement that makes up the view. But you can also...

Gift Peddie (12/7/2009)

---

zachsteve77 (12/7/2009)

---

Thanks for the response. So changing the actual user that the SQL SSIS service is running under to a domain admin would solve the problem? ...

Lets see..

A - SQL 2005 on Windows 2008 - virtual

B - SQL 2005 on Windows 2008 - virtual

A and B on same physical host.

C - SQL ???? on Windows 2003...

If it is purely inhouse then there should be NO ability to connect to SQL from outside. And even if it weren't then almost certainly anybody outside should be...

I belive in SQL 2000 you could use the ALTER VIEW command..

CEWII

zachsteve77 (12/7/2009)

---

Hope everyone is doing well. I’ve got a SQL Server 2005 question that I’m hoping is a quick and easy answer. Basically what we are trying to...

I think you might have read too much into that link you sent. I don't see anything where is says you can run 2005 packages on 2008 with no...

timscronin (12/7/2009)

---

Sorry, what I am looking for is that if I have 2 instances of SQl Server on a Standard edition SQL 2005 Active/Passive Cluster, that I expect both instances...

I am implying that the lack of 64-bit jet...

True...