Is this kinda what you are thinking? http://www.kimballgroup.com/2012/02/design-tip-142-building-bridges/

I would agree with Martin, a data mart that pulls data from your vault for reporting is a natural evolution when direct reads from the vault model are no longer...

Code seems fine - have you inadvertently disabled that script task? Possibly just running the subsequent inserts resulting in appended data?

Unfortunately, while they do fall into the same category of algorithmic offerings, they do not all offer the same performance or features. For example, SSAS is not as powerful as...

I find myself continually reminding folks that Analysis Services has had data mining features for quite some time. The while implementations may vary, algorithms all fall into the same...

Separate IIS server is where we throw stuff, along side other existing web apps and services.

Thanks, and you are absolutely correct. In this one limited instance I had a complete miss. However I did learn tons about the tools, algorithms, and skills. ...

Any thoughts on how these stack up with the scripts from Ola Hallengren that some of us know?

Beaten to the punch! Pretty good presentation from the BIML experts on how to use BIML to generate Data Vault Models

https://www.youtube.com/watch?v=QVS79-YcPsA

Thanks for the warm reception! More articles and details to follow soon. Meantime if you have any questions on specifics feel free to hit me up.

Have you looked into using cast and or convert? http://msdn.microsoft.com/en-us/library/ms187928.aspx

So would something like this do the trick?

Insert into tblTraining

(Select EMPID, 9750, 'NT' from tblEmployee)