The following article can have some great suggestions for you:

http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx

Not all best practices can be applied to your situation, but some of them ought to be useful.

Regarding the INSERTS in...

If you can't process the SQL 2000 cube with the Analysis Services Processing Task, there are alternatives to do the same.

I took the following list from the book Microsoft® SQL...

What is the exact reason that Validate External Metadata has to be set to false. I don't see the connection with transactions. Do you get any errors or warnings?

The reason...

To execute a package on the server, the user has to have permissions to execute the system stored procedure...

Read the whole file in as one column, then use a conditional split to split the data stream into 3 flows.

For each flow, use a script component to split out...

Definately learned something today. Thanks.

davepc (2/28/2011)

---

Hi Phil,

Yes. LastModifiedDateTime would work if you don't need to capture all change and don't allow deletions (which is a different story).

If you allow deletions and don't just mark...

CirquedeSQLeil (2/28/2011)

---

Worst / strangest question was "how many of _______ can fit in a bus?" The interviewer wanted to argue with my answer - which I thought was somewhat...

TravisDBA (2/28/2011)

---

Any question in an interview where your first gut feeling is "That is none of your business." Go with your gut, that is not a good question, and ask...

GSquared (2/28/2011)

---

Kiara (2/28/2011)

---

jcrawf02 (2/28/2011)

---

Stefan Krzywicki (2/28/2011)

---

jcrawf02 (2/28/2011)

---

I'm just growing tired of having to explain Microsoft's commercials to my wife. Some idiot on the screen says "To the Cloud..." and I...

quickdraw (2/28/2011)

---

#3 By reversing the kewords in the keywords table, you get a new feature no database has (without a full table scan)

One additional thing I did is to reverse...

GSquared (2/28/2011)

---

And between...

amenjonathan (2/28/2011)

---

I would say you're an intelligent guy who has no sense of humility. Bad for business. You're going to ostrisize yourself with the entire team; therefore, if I hire...

Stefan Krzywicki (2/28/2011)

---

Brandie Tarvin (2/28/2011)

---

GSquared (2/28/2011)

---

I think that's one of the reasons some companies are interested in "cloud computing", because then their code is on their server, and you can't...

Waw, you're quite an argumentative guy. And I mean that as a compliment.

Honesty over politics. I'd like to work more with people like...