Archive | January, 2007

Working with SSIS Part#1

It is often necessary when working with customer data to do import routines that will input each individual customer’s data. One way whihc is often implemented in Sales is to have the individual sales personnel input their weekly prospects into a predefined Excel spreadsheet and then to send that off to be placed on a […]

Read more

AS2005 Many-to-Many Relationships

I have been working for the past couple of months with Analysis Services 2005 and trying to get a hold on the Many-to-Many relationships. It si a pretty simple concept when you get down to it. AS2005 takes care of the many-to-many relationship and all that is required of you is to provide it with […]

Read more

Distinct Component for SSIS

If anyone has read Jamie Thomson’s piece A Distinct Component Please! .. I would like to ititerate his frustration. This seems like a simple thing for the powers that be on the business intelligence end to come up with. Of course, there have been some simple illustrations on how to do this via hash-tables and […]

Read more

SQL Server 2005 SP2

Okay so it has been about a month now since the SP2 CTP for December has been released and I am still awaiting the official release of the service pack. For those of you that are uninitiated with what the service pack contains …well, the biggest thing for me is the addition of vardecimal type. […]

Read more