Sparks from the Anvil - All Comments

Importing List Data Into SQL

Mike's Blog — Wed, 04 Jun 2008 00:56:40 GMT

A recent project I'm working on requires some data to be stored in SQL (for reporting purposes) but be

re: The FACT is that it is not so DIM after all

DrJohn — Fri, 02 May 2008 10:20:45 GMT

Thanks Piotr, I am a great fan of prefixes and acurate naming. Using a seperate schema for the cube is a great idea and exactly what I initially proposed. However, the dev team are using CodeSmith to generate their code and they tell me the tool only supports the dbo schema. Clearly my views should affect thier work, but they insisted on a single schema. Shame.

re: The FACT is that it is not so DIM after all

Piotr Rodak — Tue, 22 Apr 2008 10:09:42 GMT

So, you discovered 'hungarian' notation for databases? ;)

This is what many people flame about, and I still find it easier to organize objects if they have meaningful prefixes. Oldskul you may call it.:)

I think that using separate schema for the interface might be also a good idea.

Regards

Piotr

re: Getting a list of files from a MOSS document library using a SharePoint web service

reskatze — Mon, 07 Apr 2008 17:39:03 GMT

Thanks for this blog.

One question:

How do I get the names of the (recursive) folders?

SSIS: Calling SharePoint web services from the data flow

Sparks from the Anvil — Sun, 09 Dec 2007 17:45:19 GMT

In my previous post , I outlined how to call a SharePoint web service to obtain a list of all Excel files

SSIS: Calling SharePoint web services from the data flow

Sparks from the Anvil — Sun, 09 Dec 2007 17:45:17 GMT

In my previous post , I outlined how to call a SharePoint web service to obtain a list of all Excel files

re: SSAS: Working with date and time measures to calculate average elapse time

anandbisht — Thu, 06 Dec 2007 11:44:34 GMT

It's really hard to find tricky information when needed most and it's great to see some one is helping and sharing such useful information. Thanks to Dr. John.

I tried your solution and its works great, your earlier BI implementation been inspired to implement BI for SSC. Also the excel package example was great I have re-created package to suit with multiple template and style based on user input.

rgd/-

Cleaning Address Data with SSIS using a Web Service - Explained

Sparks from the Anvil — Sun, 18 Nov 2007 18:27:21 GMT

Jamie Thompson gave me some very helpful feedback on my recently published article over at SQLCentral.com

re: Converting C# to VB.NET for use in SSIS

Phil Brammer — Wed, 14 Nov 2007 22:34:51 GMT

Just an FYI - SQL Server 2008 SSIS will allow the use of C# in script tasks/components as SSIS implements the new VSTA architecture over the limited VSA architecture.