akirajt (7/7/2012)

---

Should the surrogate key, for instance customerKey for dimension customer, be created in the stage process and then the all data should be loaded into the dimCustomer or should...

I'm wondering where it has to go to get to the Access db and whether there are more hops to it from the server vs your workstation.

If the...

I will frequently use the script component as a deduper. There are other options but scripting gives me all the control in defining what a dupe really is for...

The answer is yes, you can limit what is in the cube. We do that frequently as our DW doesn't serve only the cubes. The datasource view for...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"subhash" ("STUD_Forename_1", "STUD_Surname", "Course", "STEN_Start_Date",...

I use parent pkg configs for several things - server, database, local file path, toggle in-pkg validation on/off...

It also passes in a parent pkg key to children so...

I generally explain a cube as a spreadsheet Gone Rubik's, as it provides slice n dice not found on a regular spreadsheet. cubes are 3d, they contain dimensions, while...

Evil Kraig F (6/21/2012)

---

herladygeekedness (6/21/2012)

---

I would love more info on how to add conditional logic to a SQL Agent job as I have not found that functionality and could certainly...

SSIS training will prepare you for building a data warehouse, so far as the ETL goes. Regardless of what end user tool is in place, the data has to...

I would love more info on how to add conditional logic to a SQL Agent job as I have not found that functionality and could certainly put it to use.

That's a stinker of a start point. You can copy the command line from the pkg setup and run it from command prompt in the hopes of getting more...

Charmer, are you saying that your toolbox is completely empty, or just missing 3rd party tools?

If the former, I'm not sure how to help unless you can right-click the toolbox...

Most of mine have a parent package that will fail if any children fail. Presumably you could do the same thing by making each child a package step and...

I have some parent package variable configurations for ServerName and such, which I can set at sql job level for input to package. I've not dealt with other config...

Not sure I'm understanding.

You say you aren't using BIDS, you're running a SQL job (stored procedure?), but then you refer to tasks such as Script Task and a packageID, which...