jncarter,

Thank you for the time you took with your response. Unfortunately, I don't think it applies in this case. I just finished search the log files for a...

One book I recommend is Worx Professional SQL Server Integration Services 2005. It is the book I keep on hand when working on SSIS packages and is the one...

hmmm, a question I sense here but not sure what you want.

Please read the article linked below regarding asking for help. If you follow the guidelines in that article,...

barbaran (1/7/2009)

---

I attached an image of the data flow.

SELECT Key

FROM databaseA.tableA (400,000 rows)

SELECT Key

, value

FROM database1.table1 (1,200,000 rows)

MERGE JOIN ON Key

86,000 records are known to match, the number...

Judy (1/7/2009)

---

our new server is production server. It will be heavily loaded. In my plan, even though we will develope DW, it should be considered to use a seperated server....

We have a...

Our PeopleSoft developers aren't too happy with the Oracle site for PeopleSoft either. Our Admin appears to be out to lunch at the moment. As soon as I...

It depends, what are you doing? We have a currently dead in the water DW project. Our DW development server has the SQL Server Database Engine and SSIS...

Several things. One, after upgrading, did you update all your statistics on the database? Also, where, from a functional view, are you experiencing the problem? We had...

Actually, this is easily done.

select replace(convert(varchar(11), getdate(), 113),' ','-')

Hard to say. No data or logic to look at to be able to know what is actually happening.

Michael Earl (1/7/2009)

---

Lynn Pettis (1/7/2009)

---

Grant Fritchey (1/7/2009)

---

I guess you can't argue with that. The worst part is that so many of them have moved North to NH and corrupted...

Grant Fritchey (1/7/2009)

---

Agreed,...

But before you post your problem, you will notice that several of us have a link to an article related to "How to ask for help" (we also use different...

Grant Fritchey (1/7/2009)

---

Lynn Pettis (1/7/2009)

---

Too...