If...

njdevils39 (3/26/2012)

---

capn.hector (3/26/2012)

---

im amazed at your patience sean. im sitting here laughing. ill save you at least one time.

We need the DDL and sample data. im supprised...

Computer name is the name of your computer.

If mirroring between instances on the same server, you have to use different ports for each instance.

Check out this link: http://msdn.microsoft.com/en-us/library/ms141747(v=SQL.90).aspx.

Welsh Corgi (3/26/2012)

---

Did you ever find a solution to this problem?

I have a job that executes 4 pages.

The last one fails with an invalid password.

I execute the Package from BIDS...

Named instances use dynamic ports. The SQL Brower service is used to identify the port that a named instance is using. These can change between restarts of the...

Can you connect to the named instances using the IPADDRESS\INSTANCENAME? Do you have SQL Browser running on the server?

njdevils39 (3/26/2012)

---

Lynn Pettis (3/26/2012)

---

Just to add, it doesn't even need to be the entire table(s). You can reduce the table(s) to the columns used in stored procedure and the...

I don't use maintenance plans. I use my own code for handling the backups/index maintenance etc.

However, you should download this book[/url].

Nope. That isn't it. I am trying to find out if you are trying to open up SSIS packages that may have been created or upgraded to SQL...

Doubt it.

Just to add, it doesn't even need to be the entire table(s). You can reduce the table(s) to the columns used in stored procedure and the key (index) columns....

bitbucket-25253 (3/26/2012)

---

Lynn Pettis (3/26/2012)

---

Evil Kraig F (3/26/2012)

---

GilaMonster (3/23/2012)

---

SQLRNNR (3/23/2012)

---

GilaMonster (3/23/2012)

---

You say that like it should be obvious it's a bad idea....

Looks like you are running SQL Server 2008, what version are the SSIS packages?

How about the DDL (CREATE TABLE statement(s)) for the base table(s) in the stored procedure, sample data for the base table(s) (as a series of INSERT INTO statements), and the...