SSIS - Sparks from the Anvil

Browse by Tags

All Tags » SSIS (RSS)

SSIS: Building SQL databases on-the-fly using concatenated SQL scripts

Over the years I have developed many techniques which help automate the whole SQL Server build process. In my current process, where I need to build entire OLAP data marts on-the-fly , I make regular use of a simple but very effective mechanism to concatenate...
Posted by DrJohn | 2 comment(s)
Filed under: , ,

SSIS: Deploying OLAP cubes using C# script tasks and AMO

As part of the continuing series on Building dynamic OLAP data marts on-the-fly , this blog entry will focus on how to automate the deployment of OLAP cubes using SQL Server Integration Services (SSIS) and Analysis Services Management Objects (AMO). OLAP...
Posted by DrJohn | 2 comment(s)

Building dynamic OLAP data marts on-the-fly

At the forthcoming SQLBits conference , I will be presenting a session on how to dynamically build an OLAP data mart on-the-fly. This blog entry is intended to clarify exactly what I mean by an OLAP data mart, why you may need to build them on-the-fly...
Posted by DrJohn | 3 comment(s)

Cleaning Address Data with SSIS using a Web Service - Explained

Explains some of the terminology needed when calling a web service from SSIS....
Posted by DrJohn | 1 comment(s)
Filed under: , ,

SSIS: Getting data from Excel files using Aspose.Cells

This article outlines how to write an asynchronous SSIS script component that uses Aspose.Cells to extract data from Excel files with complicated layouts. ...
Posted by DrJohn | with no comments
Filed under: ,

Downloading Excel files from SharePoint using SSIS

In my previous post , I outlined how to obtain a recursive list of all Excel files held in a SharePoint document library. In SSIS, I use this code to upsert records into a table which identifies which files are new or modified. Clearly I could process...
Posted by DrJohn | with no comments
Filed under: ,

SSIS: Calling SharePoint web services from the data flow

In my previous post , I outlined how to call a SharePoint web service to obtain a list of all Excel files held in a document library. However, that code was developed in Visual Studio where adding a reference to a web service is simplicity itself. Doing...
Posted by DrJohn | 3 comment(s)
Filed under: ,

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

C# example of how to get a recursive list of all documents held by document library in SharePoint 2007...
Posted by DrJohn | 8 comment(s)
Filed under: ,