Nov
3
2009

CDC for heterogeneous sources with SSIS, from Attunity and Microsoft

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 low-impact change data capture (CDC) technology, enables efficient and real-time integration of heterogeneous data with significant cost savings. ... The integrated offering of Attunity’s CDC with Microsoft’s SSIS is now available for many... [More]
Nov
3
2009

Get the new SSIS Expressions cheat sheet from PragmaticWorks

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

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

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 Belltown) include: Andaluca (a favorite of mine) Art Barolo (impossible choice between lamb and boar!) Campagne Chez Shea Dahlia Lounge (Tom Douglas) Earth & Ocean Etta's (Tom Douglas) Flying Fish Hunt Club Lola (Tom Douglas) Se... [More]
Nov
1
2009

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

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 1.4 of their SSIS+ product, adding still more often-requested features to their add-on library for SQL Server 2005 and 2008. For details on the new and existing features, please see this blog entry, CozyRoc SSIS+ 1.4 has arrived. Here is the most interesting ... [More]
Sep
30
2009

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

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 the word. Thanks,Phil  Please see my post from yesterday, New book: Learn some SSIS, help children affected by war, for more information about the book. -Doug  
Sep
29
2009

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

"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 about the book here: http://www.sqlservermvpdeepdives.com.(9/29/09: If you were one of the very first readers this morning, sorry about the mis-typed URL. It's working now.) The book contains the following 4 chapters on SQL Server Integration Servic... [More]
Sep
23
2009

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

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 I'll just quote their announcement: Lysine 1.3 Released We are excited to announce that our planned release for 1.2 was merged with features that had been planned for release in 1.3 at a later date. Due to increased international demand, we put a rush on 1... [More]
Aug
28
2009

64-bit Excel Driver in Microsoft Office 14

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 packages in 64-bit mode on 64-bit computers, rather than wrestle with obscure settings to force some packages to 32-bit mode. The next version of Microsoft Office, Office 14, will be available in a 64-bit version. This version will include a 64-bit version... [More]
Aug
28
2009

Faking success in SSIS

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 worse, their descriptions were mixed up in at least one place in Books Online (now fixed). I've just checked BOL one more time, so let's clear up the confusion before I forget which property is which. These properties apply not only to the ... [More]
Apr
30
2009

Speed up your ETL with 4 new SSIS performance videos from Microsoft

SSIS: Designing and Tuning for Performance SQL Server Video Series Learn the details of SQL Server Integration Services performance tuning from the people who know it best! Today (4/30/09) Microsoft published 4 new videos on SSIS performance, recorded by experts on the SSIS product team and the SQLCAT (Customer Advisory) team. The videos range from 12 to 16 minutes in length. Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video)by Denny Lee, Senior Progr... [More]