November 2008 - Posts

See all the new SSIS articles, videos, & samples from Microsoft
Published 18 November 8 3:16 PM | dougbert
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...
Filed under: , , ,
Your vote on Microsoft Connect influenced SQL Server 2008 Service Pack 1
Published 14 November 8 4:22 PM | dougbert
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...
Filed under:
Add logging to the Data Profiling Task
Published 11 November 8 3:27 PM | dougbert
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...
Filed under:
Learn more about using Change Data Capture (CDC) in SSIS 2008
Published 10 November 8 5:11 PM | dougbert
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...
InfoWorld praises Lookup caching, CDC in SSIS 2008
Published 5 November 8 11:3 AM | dougbert
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...
Filed under: , ,
Check out the new Integration Services portal page on MSDN
Published 3 November 8 5:31 PM | dougbert
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...
Filed under: ,