Dougbert on SSIS

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

Published Sun, Jan 15 2012 8:53 AM by dougbert

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

Published Wed, Apr 20 2011 9:24 AM by dougbert

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

Published Fri, Jan 07 2011 10:01 AM by dougbert

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

Published Mon, Dec 06 2010 11:54 AM by dougbert

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

Published Sat, Dec 04 2010 11:26 AM by dougbert

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

Published Sun, Nov 28 2010 8:39 AM by dougbert

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

Published Sun, Nov 07 2010 8:27 PM by dougbert

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

Published Sat, Nov 06 2010 7:16 AM by dougbert

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

Published Wed, Oct 20 2010 5:20 PM by dougbert

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

Published Sun, Sep 26 2010 5:04 PM by dougbert

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

Published Sun, Sep 12 2010 3:55 PM by dougbert

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

Published Thu, Sep 09 2010 4:38 PM by dougbert

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

Published Wed, Sep 01 2010 11:50 AM by dougbert

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

Published Mon, Aug 23 2010 1:52 PM by dougbert

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

Published Wed, Aug 11 2010 11:00 AM by dougbert

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

Go directly to . . .

Blog Search Form

Syndication

Tags

Dougbert Visitors

Archives