Dougbert on SSIS

Thank you for following me. Comments are now disabled.

dougbert — Sun, 07 Feb 2010 00:13:00 GMT

Thank you all for following my "Dougbert on SSIS" blog. As I mentioned in a recent post , I am no longer working on SQL Server Integration Services at Microsoft. While I still expect to spend time with SSIS, I won't have as much time or...(read more)

You could be doing ETL or BI at Microsoft!

dougbert — Mon, 18 Jan 2010 17:15:00 GMT

If you enjoy using the features of SQL Server for ETL or business intelligence projects, consider working close to the source right here at Microsoft. Check out our public careers page at: https://careers.microsoft.com/ . The other day I just happened...(read more)

SSIS: Now it's play and not work!

dougbert — Thu, 07 Jan 2010 23:48:00 GMT

For me, that is. I hope. No, I haven't written any magic code that fixes the tedious parts of Integration Services. But in 2010 I will no longer be working on SSIS documentation at Microsoft; I am moving to a new and different role on the SQL Server...(read more)

Importing from Excel: IMEX and mixed data types

dougbert — Sat, 21 Nov 2009 22:15:00 GMT

When we talk about using import mode, "IMEX=1," to resolve a common problem when importing from Excel, we sometimes give or get the impression that setting IMEX=1 automatically imports all data as text. This is an over-simplification. In fact...(read more)

Updated component: Refresh SSRS reports directly from an SSIS package

dougbert — Mon, 09 Nov 2009 21:29:00 GMT

My German's a little rusty, but I still try to follow the German-language SSIS blog by Tillman Eitelberg of Bonn, Germany. In yesterday's posting , he talks about his Report Generator Task project on Codeplex (in English). Many of you have probably...(read more)

New book: SSIS Problem - Design - Solution

dougbert — Mon, 09 Nov 2009 18:32:00 GMT

Microsoft SQL Server 2008 Integration Services Problem-Design-Solution by Erik Veerman, Jessica Moss, Brian Knight, and Jay Hackney ISBN: 978-0-470-52576-0 Paperback, 480 pages Published by Wiley/Wrox in November 2009 List price: US $49.99 Amazon price...(read more)

CDC for heterogeneous sources with SSIS, from Attunity and Microsoft

dougbert — Tue, 03 Nov 2009 18:20:00 GMT

See the press release from yesterday (11/2/2009): Attunity extends its partnership with Microsoft to enable heterogeneous Change Data Capture Some excerpts: The solution, based on Microsoft’s SQL Server Integration Services (SSIS) and Attunity’s...(read more)

Get the new SSIS Expressions cheat sheet from PragmaticWorks

dougbert — Tue, 03 Nov 2009 16:59:00 GMT

Available as both a Web page and a downloadable PDF at http://www.pragmaticworks.com/cheatsheet/ . ...and more! -Doug...(read more)

Off topic: Seattle restaurant deals just in time for SQL PASS 2009

dougbert — Mon, 02 Nov 2009 20:53:00 GMT

If you're in Seattle for SQL PASS 2009, and you have an appetite for fine Seattle food but you don't have an unlimited budget, there are several November deals to consider. 3-course prix fixe dinners for $30 Restaurants in the downtown area (including...(read more)

Updated product: SSIS+ 1.4 from Cozyroc - Visit CozyRoc at PASS

dougbert — Mon, 02 Nov 2009 01:17:00 GMT

Cozyroc is exhibiting at SQL PASS 2009 for the first time this year. From the Cozyroc Web site : CozyRoc will be exhibiting at the Premier Conference for SQL SERVER Professionals. Visit CozyRoc at booth #508 and say HI. Cozyroc has just released version...(read more)

Save 50% today only on new book, SQL Server MVP Deep Dives

dougbert — Wed, 30 Sep 2009 16:53:00 GMT

I got this reminder from MVP Phil Brammer: FYI - You can use the code, pop0928, at checkout from www.sqlservermvpdeepdives.com during the month of September (what's left of it anyway) to save 50% . That is a public code, so please feel free to spread...(read more)

New book: Learn some SSIS, help children affected by war

dougbert — Tue, 29 Sep 2009 16:04:00 GMT

" SQL Server MVP Deep Dives ," a result of collaboration among 53 SQL Server MVP's and others, is now available for pre-order. The authors are generously donating all their royalties to a charity for children affected by war. Find out more...(read more)

Updated product: EBCDIC Source component "Lysine" from Amino Software

dougbert — Wed, 23 Sep 2009 22:10:00 GMT

Patrick & Ben at Amino Software have announced a new version of "Lysine," an Integration Services source component for loading EBCDIC data into the data flow of an SSIS package. I wouldn't know an EBCDIC if one ran up and bit me, so...(read more)

64-bit Excel Driver in Microsoft Office 14

dougbert — Fri, 28 Aug 2009 22:06:00 GMT

First, the good news... If you use SQL Server Integration Services to load data to or from Excel files or Access databases, then a 64-bit driver is headed your way. This is great news for SSIS users in a 64-bit world. Soon you'll be able to run your...(read more)

Faking success in SSIS

dougbert — Fri, 28 Aug 2009 20:14:00 GMT

A SQL Server Integration Services package has a set of properties with similar names that let you: force the result of running the package return a custom value from the package Their similar names make it easy to confuse these properties. To make matters...(read more)