November 2009 - Posts

Importing from Excel: IMEX and mixed data types

Published 21 November 9 3:15 PM | dougbert

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

Filed under: Excel

Updated component: Refresh SSRS reports directly from an SSIS package

Published 9 November 9 2:29 PM | dougbert

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

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

New book: SSIS Problem - Design - Solution

Published 9 November 9 11:32 AM | dougbert

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

Filed under: mvp, books

CDC for heterogeneous sources with SSIS, from Attunity and Microsoft

Published 3 November 9 11:20 AM | dougbert

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

Filed under: third-party products, vendors, cdc

Get the new SSIS Expressions cheat sheet from PragmaticWorks

Published 3 November 9 9:59 AM | dougbert

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

Filed under: expressions

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

Published 2 November 9 1:53 PM | dougbert

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

Filed under: off topic

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

Published 1 November 9 6:17 PM | dougbert

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

Filed under: third-party products