Douglas Laudenschlager

See all the new SSIS articles, videos, & samples from Microsoft

dougbert — Tue, 18 Nov 2008 22:16:00 GMT

Have you seen all the recent articles, videos, & samples for Integration Services? In the future, we hope to offer you an RSS feed for this purpose, but we're not there yet. For now, I hope that you find this list useful, especially since it was...(read more)

Your vote on Microsoft Connect influenced SQL Server 2008 Service Pack 1

dougbert — Fri, 14 Nov 2008 23:22:00 GMT

Your vote counts on Microsoft Connect! The SQL Server product team looked closely at Connect bugs from our customers to plan the fixes that will be included in SQL Server 2008 Service Pack 1. After setting aside feature requests (DCRs), they started at...(read more)

Add logging to the Data Profiling Task

dougbert — Tue, 11 Nov 2008 22:27:00 GMT

Yesterday I was on a call where we looked at a few usability requests for the Data Profiling Task that didn't make it into RTM. One such request was task-specific logging. Surprise! The attentive developer at Microsoft Research had added it at the...(read more)

Learn more about using Change Data Capture (CDC) in SSIS 2008

dougbert — Tue, 11 Nov 2008 00:11:00 GMT

SQL Server 2008 Enterprise includes the new Change Data Capture feature, or CDC, largely intended for use by ETL developers performing incremental loads of a data warehouse. With CDC, you can easily identify rows that have been inserted, updated, or deleted...(read more)

InfoWorld praises Lookup caching, CDC in SSIS 2008

dougbert — Wed, 05 Nov 2008 18:03:00 GMT

Read what Sean McCown of InfoWord says about the benefits of Lookup caching and Change Data Capture for the enterprise. "Microsoft has taken some big steps to ensure that SSIS (SQL Server Integration Services) can compete directly with competitors...(read more)

Check out the new Integration Services portal page on MSDN

dougbert — Tue, 04 Nov 2008 00:31:00 GMT

When you visit the Integration Services page on MSDN or TechNet, you now get fresh and useful links that include community content, rather than a stale set of links to Books Online topics. Here on the Integration Services team, we're happy to be the...(read more)

ETL in the cloud, or just for the cloud?

dougbert — Mon, 27 Oct 2008 21:48:00 GMT

Lots of comments today about PDC and the Microsoft executives discussing Windows Azure, the new platform for cloud computing. "Everyone" - that is, Matthew Roche and Jamie Thomson - noticed (without even being present!) the "ETL" on...(read more)

Didn't make it to the recent Microsoft BI Conference?

dougbert — Tue, 21 Oct 2008 23:33:00 GMT

Well, you saved a ton of money, but missed a lot of fascinating presentations. Each hour brought another panicked decision over which talk to choose, from the several available tracks. (Except when Donald Farmer's title promised to make me "cool...(read more)

MSDN publishes first 2 articles by Integration Services product vendors

dougbert — Tue, 21 Oct 2008 23:14:00 GMT

MSDN/TechNet has just published 2 new articles by third-party vendors of commercial products that work with, or complement, SQL Server Integration Services. In Extending Integration Services with the Script Task and Script Task Plus , Ivan Peev of CozyRoc...(read more)

Connectors now available for SAP BI, Oracle, and Teradata

dougbert — Tue, 21 Oct 2008 23:03:00 GMT

Both of the promised post-RTM packages of connectors for use with SQL Server 2008 Enterprise and Developer are now available for download, since last Friday's release of the October Feature Pack that contains the SAP BI connector. Each set consists...(read more)

New 10-minute how-to videos on Integration Services

dougbert — Thu, 16 Oct 2008 18:30:00 GMT

The Integration Services documentation team at Microsoft recently published its very first batch of 10-minute how-to videos. We hope that beginning to intermediate users will find these useful, and we're pleased to be taking some first steps beyond...(read more)

Setting an expression dynamically

dougbert — Sat, 11 Oct 2008 23:53:00 GMT

Former Integration Services developer Michael Entin recently responded to an interesting question on the internal SSIS discussion list at Microsoft. The user was asking: How can I assign the expression [in this case, for the Derived Column transformation...(read more)

The first Integration Services 2008 book is now available

dougbert — Thu, 09 Oct 2008 22:53:00 GMT

http://www.amazon.com/gp/product/0470247959/ Professional Microsoft SQL Server 2008 Integration Services by SQL Server MVPs Brian Knight and Erik Veerman, our own broadly smiling Grant Dickinson, and industry experts Douglas Hinson and Darren Herbold...(read more)

New "social bookmarking" features on MSDN & TechNet

dougbert — Wed, 10 Sep 2008 17:47:00 GMT

I thought you might want to take a look at this blog posting - Launched: Social Bookmarking V1 on MSDN and TechNet - although I haven't had the leisure to explore it yet myself. The stated goal is: " These new sites, which have been available...(read more)

New MSDN articles on Integration Services deployment and performance

dougbert — Wed, 03 Sep 2008 17:41:00 GMT

The Microsoft MVPs and consultants who spend every day implementing real-world solutions with SQL Server Integration Services gain a wealth of practical knowledge that even the development team can't match. So we're very pleased to announce a...(read more)