I have another question, are you going to be using Enterprise Edition? If not Fuzzy Lookup isn't available.

CEWII

ok..

CEWII

I guess I'm unsure what you are getting at..

master, model, tempdb, and msdb are ALWAYS named the same regardless of named or default instance. Everything else is in question..

CEWII

I should have asked this earlier.

Instead of telling us how you want to solve the problem why don't you tell us what problem you are trying to solve.

CEWII

Lowell (3/12/2010)

---

I'm with Elliot; you can assume that the dbID < 4, but, on my SQL 2008, I have 6 db's i'd call system db's:

master

tempdb

model

msdb

ReportServer

ReportServerTempDB

I think you are limited to...

A lot depends on your requirements. If you have to satisfy PCI then the requirements are different. Your architecture can make a big difference as well. I...

I think this might be taking an anti-hard coding stance to far. Trust me, I'm generally against hardc-coding but since the system databases are the same everywhere and in...

I don't believe there is one, but we know what they are..

master

model

msdb

tempdb

CEWII

Great, I'll...

Gianluca Sartori (3/12/2010)

---

RBarryYoung (3/12/2010)

---

It's the light-sabers, you're both using green on the left side. I get them mixed...

I think the easiest would be to create a script task that used the system.io namespace to look and see if the file exists if not fail that task and...

They are no trusts required for SQL Authentication, that is the point of SQL Authentication. If you have a valid username and password you can login. That is...

You can probably add the variable using a Derived Column task and the OLE DB Command task. If you are moving a lot of data this is going to...

Jeff Moden (3/10/2010)

---

Jack Corbett (3/10/2010)

---

Elliott W (3/10/2010)

---

I'm wondering if any of the "regulars" would be interested in peer-reviewing an article related to SSIS processing concurrency. I've had a lot...

1. See that attached dtsx file in the zip..

2. Usually if it dies in process it will rollback. Depending on settings.

CEWII