Blogs

Broken links for images and file downloads on this blog site

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/...

Posted to Dougbert on SSIS by dougbert on 01-15-2012

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

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...

Posted to Dougbert on SSIS by dougbert on 04-20-2011

Excel driver not supported on the server

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...

Posted to Dougbert on SSIS by dougbert on 01-07-2011

Filed under: Excel

PowerShell with SSIS: More insights, installable extensions

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...

Posted to Dougbert on SSIS by dougbert on 12-06-2010

Filed under: PowerShell

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

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...

Posted to Dougbert on SSIS by dougbert on 12-04-2010

Filed under: third-party products, videos, vendors, spatial

Exploring the SSIS discussion with Social Gadgets

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...

Posted to Dougbert on SSIS by dougbert on 11-28-2010

Off topic: Programmatically creating a tag cloud in C#

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...

Posted to Dougbert on SSIS by dougbert on 11-07-2010

Filed under: programming, off topic

Webcast: Unlock the spatial data stored in Microsoft SQL Server

(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...

Posted to Dougbert on SSIS by dougbert on 11-06-2010

Filed under: Codeplex, spatial

More affordable spatial data loading for SQL Server

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...

Posted to Dougbert on SSIS by dougbert on 10-20-2010

Filed under: third-party products, vendors, spatial

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

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...

Posted to Dougbert on SSIS by dougbert on 09-26-2010

Filed under: third-party products, data quality, data profiling task

API reference for built-in SSIS data flow components

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...

Posted to Dougbert on SSIS by dougbert on 09-12-2010

Filed under: programming, custom components, BOL

SSIS and Microsoft Live Labs Pivot

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...

Posted to Dougbert on SSIS by dougbert on 09-09-2010

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

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...

Posted to Dougbert on SSIS by dougbert on 09-01-2010

Filed under: known issues, Excel, 64-bit

Restarting SSIS packages after failure

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...

Posted to Dougbert on SSIS by dougbert on 08-23-2010

Filed under: clustering, high availability

Running multiple SSIS Foreach Loops in parallel

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...

Posted to Dougbert on SSIS by dougbert on 08-11-2010

Filed under: third-party products, custom components, vendors

Go directly to . . .

Tags

Dougbert Visitors