the BI plumber

tag:blogger.com,1999:blog-3169114974717396242024-09-01T06:20:07.745-04:00the BI plumber...bringing blue-collar work ethics to the Business Intelligence arena.Anonymoushttp://www.blogger.com/profile/01129779758432406219noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-316911497471739624.post-30009339024695384332009-11-13T21:00:00.001-05:002009-11-13T21:01:07.678-05:00Recursive Common Table Expressions

Problem:  I need to load a lot of dummy data into a table and time is limited. Solution:  Common Table Expressions (CTE) used in a recursive fashion.  Here is an excellent demo on how CTE’s can be used recursively:  http://www.simple-talk.com/content/print.aspx?article=260 Example: SET NOCOUNT ON CREATE TABLE [sqlCTE]([field_bigint] [bigint] NULL) ON [PRIMARY] GO

Anonymoushttp://www.blogger.com/profile/01129779758432406219noreply@blogger.com0tag:blogger.com,1999:blog-316911497471739624.post-4453529206420812802009-10-28T19:37:00.001-04:002009-11-07T00:33:52.163-05:00Rounding issues with OLE DB Destination in SSIS

Problem:  Your MS Excel source data holds a value, 12.3456789.  You need to INSERT this value into a SQL Server destination table with a column of type decimal(19,2).  The desired result is 12.35, however when you use the SSIS Data Flow Task with the OLE DB source and destination components, your result is 12.34.  By default, the underlying code in the SSIS task will truncate

Anonymoushttp://www.blogger.com/profile/01129779758432406219noreply@blogger.com0tag:blogger.com,1999:blog-316911497471739624.post-50901882947197232672009-10-22T22:13:00.008-04:002009-10-22T22:46:33.662-04:00Demystifying the SSIS PIVOT and UNPIVOT Data Flow Tasks

From a high-level, general point of view: PIVOT:  turns ROWS into COLUMNS UNPIVOT:  turns COLUMNS into ROWS From a graphical point of view: PIVOT: UNPIVOT: From another graphical point of view: PIVOT: UNPIVOT: From a logical point of view: PIVOT:  If you need to summarize or group your row data, most likely you will need to use the PIVOT task UNPIVOT:  If you have a

Anonymoushttp://www.blogger.com/profile/01129779758432406219noreply@blogger.com0tag:blogger.com,1999:blog-316911497471739624.post-91705289769372449232009-10-12T23:27:00.000-04:002009-10-12T23:27:24.084-04:00Hello world!

Thanks for visiting, here you will find BI posts from a long time .NET developer newly turned Data Architect!  I hope you will find answers to your BI-related questions.

Anonymoushttp://www.blogger.com/profile/01129779758432406219noreply@blogger.com0