Dougbert on SSIS

Broken links for images and file downloads on this blog site

dougbert — Sun, 15 Jan 2012 15:53:00 GMT

The links to images and to files available for download are currently broken on this inactive blog. I apologize for the inconvenience. Please continue to follow my blog at its new address and subscribe to the feed: New blog: http://dougbert.com/blog/...(read more)

Please re-subscribe to my Dougbert blog at its new address

dougbert — Wed, 20 Apr 2011 16:24:00 GMT

The address of my Dougbert blog has changed slightly. Please re-subscribe to my blog feed at this new address: Feed address: http://feeds.feedburner.com/DougbertsBlog Web address: http://dougbert.com/blog/ I plan to continue blogging about SSIS and other...(read more)

Excel driver not supported on the server

dougbert — Fri, 07 Jan 2011 17:01:00 GMT

This statement about the ACE Provider and its Excel driver caught my attention on an internal discussion list at Microsoft on 12/26/2010: "The current support position from the Office team responsible for the ACE provider (both 32-bit and 64-bit...(read more)

PowerShell with SSIS: More insights, installable extensions

dougbert — Mon, 06 Dec 2010 18:54:00 GMT

Occasionally in the past I've mentioned approaches to using PowerShell to manage SQL Server Integration Services (SSIS). More recently I came across Sev17 , the blog of PowerShell fiend Chad Miller . Chad has found limitations in the SSIS API that...(read more)

Dec 14 webinar - Loading Spatial Data into SQL Server with FME

dougbert — Sat, 04 Dec 2010 18:26:00 GMT

I have mentioned SAFE Software before as the most visible provider of tools and components for working with spatial data in Microsoft SQL Server, with or without Integration Services. SAFE recently announced a free 1-hour Webinar on Tuesday, December...(read more)

Exploring the SSIS discussion with Social Gadgets

dougbert — Sun, 28 Nov 2010 15:39:00 GMT

These fascinating SocialGadgets from FUSE Labs at Microsoft Research give us some insight into current discussions about SQL Server Integration Services in the social media. Read more about the projects from FUSE Labs in this blog post from LiveSide.Net...(read more)

Off topic: Programmatically creating a tag cloud in C#

dougbert — Mon, 08 Nov 2010 03:27:00 GMT

Today I searched for sample code for creating a tag cloud, for a little project that I have in mind. Assuming that you already have tags (or categories) and a weighting factor, you may find these code samples and user controls interesting. Most of them...(read more)

Webcast: Unlock the spatial data stored in Microsoft SQL Server

dougbert — Sat, 06 Nov 2010 14:16:00 GMT

(I received this invitation at Microsoft, and was encouraged to invite my "customers and partners." First, take a look at this output from the DataConnector to whet your appetite...) Understanding Web Mapping and Data Visualization using DataConnector...(read more)

More affordable spatial data loading for SQL Server

dougbert — Thu, 21 Oct 2010 00:20:00 GMT

Do you have spatial data stored in ESRI Shapefiles, MapInfo TAB files, MIF/MID files, or CSV files that you have to load into SQL Server? If you do, then this new and more affordable product from SAFE Software may meet your needs. SAFE has quietly released...(read more)

Data profiling for SSIS with plug-in rules of your own

dougbert — Mon, 27 Sep 2010 00:04:00 GMT

Tillman Eitelberg has blogged a sneak preview with screen shots of his company's new datenfabrik.profiler , which will run as a component in the data flow of a SQL Server Integration Services (SSIS) package. Till will present the beta version of the...(read more)

API reference for built-in SSIS data flow components

dougbert — Sun, 12 Sep 2010 22:55:00 GMT

Developers who want to create and update SSIS packages programmatically often wonder, " Where the heck is the API reference for all the built-in data flow sources, transformations, and destinations? " The short answer is: There isn't any...(read more)

SSIS and Microsoft Live Labs Pivot

dougbert — Thu, 09 Sep 2010 23:38:00 GMT

Rats, I'm too late! For some time, I've been fantasizing (without doing any actual work) about the potential synergies between SQL Server Integration Services (SSIS) and Microsoft Live Labs Pivot (not to be confused with PowerPivot). I thought...(read more)

Making SSIS work with the 64-bit Excel (ACE) provider

dougbert — Wed, 01 Sep 2010 18:50:00 GMT

I've previously blogged about the challenges of the new 64-bit ACE Provider that includes the Excel driver, since the 32-bit and 64-bit versions cannot be installed side-by-side. In this detailed post that includes screen shots, Hrvoje Piasevoli from...(read more)

Restarting SSIS packages after failure

dougbert — Mon, 23 Aug 2010 20:52:00 GMT

Last week while I was on vacation, my Microsoft colleague Steve Howard posted another detailed article on an aspect of SSIS that's frequently misunderstood - restarting SSIS packages after a failure . Steve is often asked to explain and demonstrate...(read more)

Running multiple SSIS Foreach Loops in parallel

dougbert — Wed, 11 Aug 2010 18:00:00 GMT

The Parallel Loop Task , recently released in beta by Cozyroc Software , " can execute multiple iterations of the standard Foreach Loop Container concurrently. In tests, a CPU intensive sequential process when executed in parallel on 4-core machine...(read more)