Wednesday, August 06, 2008

SQL Server 2008 SSIS Cribsheet

Great intro to the new features in SSIS 2008.

Key takeaways:

  • c#/web services within scripts
  • better performance and caching
  • Data Profiling
  • Intelligent mapping of data types

Things I don’t get:

“The biggest advantage to this change is that you can have BIDS 2005 and BIDS 2008 installed on the same machine”

Doesn’t seem like an advantage to me to have more disk space used up, instead of a backwards-compatible development environment.

Here’s a link to the article.

SSIS 2008 Crib sheet

For things you need to know rather than the things you want to know

SQL Server 2008 SSIS Cribsheet

No comments: