Jan
26
2009

View Help for the SAP BI Connector for SSIS on the Web

Today the Help file for the Microsoft Connector 1.0 for SAP BI was published to the MSDN Library at this address: http://msdn.microsoft.com/en-us/library/dd326764.aspx. Previously, customers who were interested in the Connector had to download the components and install them to get access to the Help documentation. This Help content (which does not contain screen shots) complements the valuable how-to article (which DOES contain screen shots) by Chunhui Zhu, Using SQL Server 2008 Integration Services with ... [More]
Jan
20
2009

Learn more about Data Profiling in SQL 2008: A compilation

Microsoft Research contributed the Data Profiling Task and Data Profile Viewer to Integration Services in SQL Server 2008. Best of all, this feature is available in all editions of SQL Server that include SSIS, and not just in Enterprise. Learn more about this new task from the following resources. By their nature, SSIS package developers see the XML output from the Data Profiling task, and immediately want to process it in an SSIS package! I've marked the 3 relevant resources below with an asterisk (*... [More]
Jan
19
2009

Learn more about Lookup and its new features: A compilation

The SQL Server Integration Services team added valuable new caching options (and scalability) to the Lookup transformation in SQL Server 2008. Learn more about these enhancements (and about the Lookup transformation in general) from the following resources. Microsoft resources In SQL Server Books Online (BOL) Upgrading Lookup Transformations The section Caching the Reference Dataset in the Lookup Transformation topic. How to: Implement a Lookup in No Cache or Partial Cache Mode How to: Implement a Looku... [More]
Nov
10
2008

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

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 -- no more need for complex queries and other custom solutions! The other day I promised links to some resources, and now they're finally all online. Try the 2 new end-to-end samples on Codeplex Sandra Ward, the developer of CDC, has done extraordinary w... [More]
Nov
5
2008

InfoWorld praises Lookup caching, CDC in SSIS 2008

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 such as Informatica by offering lookup caching and CDC.  ...both lookup caching and CDC can improve the speed of loads by orders of magnitude." InfoWorld praises Lookup caching, CDC in SSIS 2008 How can you learn more about the new features in Lo... [More]
Oct
21
2008

Connectors now available for SAP BI, Oracle, and Teradata

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 of a connection manager, source, and destination, and is available in both 32-bit and 64-bit versions. In both cases, Microsoft took advantage of the existing expertise of third-party companies to develop these high-performance connectivity components. ... [More]
Oct
9
2008

The first Integration Services 2008 book is now available

 http://www.amazon.com/gp/product/0470247959/ Professional Microsoft SQL Server 2008 Integration Servicesby SQL Server MVPs Brian Knight and Erik Veerman, our own broadly smiling Grant Dickinson, and industry experts Douglas Hinson and Darren Herbold At this writing, US $31.49 on Amazon.com and in stock. Although this is the 2008 update to the 2005 version of the book, it has been massively updated with new material. It has also been carefully tech reviewed by yours truly and several other memb... [More]
Aug
12
2008

Visual Studio SP1 requirement for SQL Server 2008

SQL Server MVP Phil Brammer has already blogged about the fact that, if you have Visual Studio 2008 installed, you have to install VS 2008 Service Pack 1 before installing SQL Server 2008 "Katmai". Why? Because Katmai contains bits and pieces of SP1, and will refuse to install over VS 2008 RTM. (Just to make life more interesting, Microsoft didn't release VS 2008 SP1 until several days after SQL Server 2008.) You can read a good blog post that summarizes the entire issue, and explains the de... [More]
Jul
19
2008

Conversion should be your own decision!

No, this isn't my first religious posting! We're talking about the SQL Server Import and Export Wizard, which was built upon Data Transformation Services (DTS) in SQL Server 2000, and is now built upon Integration Services in SQL Server 2005 and 2008. Some users have complained that the new wizard is more troublesome than the DTS wizard. "I never used to get errors in the good old days of DTS." But life was not all good. You didn't get so many errors and warnings from the DTS wizard because it som... [More]
Jul
2
2008

SQL Server 2008 Feature Pack and Integration Services

Bloggers (like my pal Buck Woody on his Carpe Datum blog) are mentioning the SQL Server 2008 Feature Pack. The so-called Feature Pack is a Web page that lists many individual downloads related to SQL Server 2008. Here are some of the features of the Feature Pack, especially as they relate to Integration Services: If you have SQL Server 2008, you already have many of the items listed on the Feature Pack page. The only item in the list that's specific to SSIS/DTS is the Microsoft SQL Server 2005 Backw... [More]