You could do this within SSIS via a script task or you could do the same thing with other tools such as PowerShell. With what you describe, you won't be...

Hello James,

We've done this in the past but now call an SSIS package that controls the processing.

For the command line processing we called a .xmla file with...

Hello BJ,

Not sure how far you have gone with this yet but I would be interested in learning about your experiences.

Here is a link in case you've not gotten too...

It sounds like you're trying to juggle the two tests at a time. Focus in on one, probably the one you've studied the most for at this point, and...

Hello Andy,

My recommendation is to de-normalize the two order tables (header and line) into one factOrder table in your data mart.  Not knowing the details such as data size, how...