Some of the most important things of the ETL that you must document:

* data mapping (given a certain output column, which are the contributing input columns)

* information liquidity model: describes...

I think it is best that you include brackets, or otherwise...

What are the errors that you are getting? Can you copy-paste the exact error messages?

And even more important: what are the requirements of your SSIS package? What are you trying...

Shark Energy (8/27/2010)

---

Yes but i'm pretty sure any precedence constraints requiring an expression to be met will not be met and therefore it will not move to the only enabled...

Andrew Notarian (8/27/2010)

---

I still do not have the magic way to take 1000 general cells that are numbers and not lose the 2 strings at the end. If I...

WayneS (8/27/2010)

---

Just one point of clarification: the issue isn't with DTS/SSIS. It's with the Jet driver, used to access Excel spreadsheets by those programs. The same problem will show up...

Disable all the other tasks and run the whole package.

This is a very, very, very common problem with SSIS and Excel. It shows up in hundreds of blog and forum posts.

And apparently it existed already in DTS.

The issue is...

Well, if you have Management Studio (SSMS), then you can script them! (what a wonderful world).

Go to SSMS, make sure you have the object explorer details window open and then...

Good question. It points out that you have to be very careful with implicit conversions.

A data warehouse is in most systems indeed like a relational database. The biggest difference is that traditional databases tend to keep only operational records in a normalized table structure,...

Hugo Kornelis (8/26/2010)

---

The variable is actually declared once. Declarations are not relly executable statements. They are processed when a batch is parsed, not when it it executed. The declaration has...

Great question. I got it wrong though. I do not really understand how the scope of the type variable works. It seems you can define it over and over again,...

I would go with option 1. You don't need .NET to execute...

Did you set-up the dimension usage correctly?