SSIS and the SQL 2008 MERGE Statement for Insert, Update and Delete...

Audit Dimensions in SQL/SSIS 2008

I've read The Micorosoft Data Warehouse Toolkit and would like to implement the audit dimension and logging set up described in that book. However, I believe the download from the book's site is for SSIS 2005. Has anyone published an updated framework for

Updating Fact Table : Best practice

Hi, Ssystem used : Windows 2003 srv SQL Server 2005 STD for the OLTP SQL Server 2005 Ent for the DW with - SSIS for the ETL - SSAS for the cube ASP.NET control to display the OLAP for the user I know theres is not "one size fits

SSIS Frameworks. Automatic Rollbacks, and Poorly Designed OLTP Sources

I've purchased the excellent book Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution and read it cover to cover a few times.

Flat File Importing via SSIS - Best approach?

My company is frequently faced with the need to import and profile flat files submitted by various prospects and customers. These customers rarely provide us with a format file and when they do it is rarely accurate. Importing CSV files is slightly easier

Time dimension - update

Hi, I was not sure if this question was for ETL or here ;-) This is the situation : I have created a DW and a cube for statistic for Paramedic events. I'm working for the governement of canada and they are using some unusual financial period (13

SSIS SCD Component

We are using (or attempting to use) the Kimball Method SSIS Slowly Changing Dimension Component for SSIS from Todd McDermid (http://kimballscd.codeplex.com/). We have run into a few issues and would appreciate some advice if anyone has used this SSIS

Constitutional Conservatism: A Statement for the 21st Century / Sign the Statement

The Mount Vernon Statement is not geared to any election or candidate or specific piece of legislation; it is a statement of timeless principles as old as the Republic, and will be as relevant years from now as it is today. The Mount Vernon

Insert <actor> and as role (show) as keyword IPTCs into actor images

Hi Being playing with image and face recognition in picasa, and so thought it'd be interesting to "face match' the images that are downloaded. Then I thought this could be extended to displaying within MC... So first off I parsed (hackily) the

SQL Server 2008, page compression and indexing

Thought I'd share... We are using SQL Server 2008. A staging table loaded with data from the source system had Page Compression turned on. We saw a 50% reduction in space with no significant reduction in performance. Added a clustered index and

Insert Background Music

Background music Time to time if you want to make your forum more attractive then you can think about adding some nice background music to it. However please don't forget that html background music needs more bandwidth. The usually used mp3 files

Waddle Dee *Minor Update*

Stance- Walk- Run- Dash- Jump (start)- (loop)- Double jump- Falling- Land- Crouch- Specials Neutral Special- Spear throw- spear- How it works:Dee throws a spear, simple as that. Air - The Same Side Special- (repeat twice,

Philippine Basketball Association

All PBA fans converge here...Ginebra die hards, pasok na... not really much of a PBA fan...though i watch it from time to time... I like Kelly Williams a lot!! galing nya maglaro!!

PanImage Media Tablet 7" Touchscreen Google Android WiFi Multimedia for $129.95 free shipping at QVC

This is just like Maylong M-150 and Flytouch/ePads with 24-pin connector Price shown on QVC is $153.99 too much money for these. It only cost in China $60 bucks! This one can use the latest Tablet Zone Tz21111c ROM MOD. Take multimedia to the