Browse by Tags

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

Published 26 January 9 5:32 PM | dougbert

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...

Filed under: 2008, SAP

Learn more about Data Profiling in SQL 2008: A compilation

Published 20 January 9 4:42 PM | dougbert

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...

Filed under: 2008, data profiling task

Learn more about Lookup and its new features: A compilation

Published 19 January 9 3:4 PM | dougbert

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...

Filed under: 2008, lookup

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...

Filed under: 2008, Codeplex, samples, cdc, change data capture

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: 2008, lookup, cdc

Connectors now available for SAP BI, Oracle, and Teradata

Published 21 October 8 4:3 PM | dougbert

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...

Filed under: 2008, SAP, teradata, connectivity, oracle, downloads

The first Integration Services 2008 book is now available

Published 9 October 8 3:53 PM | dougbert

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...

Filed under: 2008, books

Visual Studio SP1 requirement for SQL Server 2008

Published 12 August 8 8:42 AM | dougbert

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...

Filed under: setup, 2008, known issues

Conversion should be your own decision!

Published 19 July 8 11:2 AM | dougbert

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...

Filed under: 2008, Import and Export Wizard

SQL Server 2008 Feature Pack and Integration Services

Published 2 July 8 1:14 PM | dougbert

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...

Filed under: setup, DTS, 2008

Not for use with the SendMail task!

Published 25 June 8 3:33 PM | dougbert

Hey, someone finally told those Marketing folks that there's something other than coffee mugs and polo shirts! But I wasn't expecting...US postage stamps! Sure enough, now you can mail your bill payments with a SQL Server 2008 stamp... Click the...

Filed under: 2008, off topic

Upgrading Custom Components for SQL Server 2008 Integration Services

Published 11 June 8 7:44 AM | dougbert

The SQL Server 2008 Books Online page in which we describe the steps for upgrading and redistributing custom components is now live: Upgrading Custom Objects for SQL Server 2008 Integration Services This topic is for shops that wrote a custom component...

Filed under: 2008, custom components, upgrade

Adding a VSTA Script task programmatically (revised)

Published 24 May 8 8:55 AM | dougbert

[UPDATED WITH A BETTER CODE SAMPLE FOR THE 2ND SCENARIO TUE 6/10/08] The move in SQL Server 2008 Integration Services from VSA to VSTA for scripting doesn't just give us C# and a better IDE and Add Reference dialog. It has also made programmatic manipulation...

Filed under: 2008, Script task, programming

Expanded "Feature Selection" page in the SQL Server 2008 Setup Wizard

Published 15 May 8 11:18 AM | dougbert

Just when I thought that I was finally finished with our Setup-related topics! Those wily Setup folks added items to the "Feature Selection" page in the SQL Server 2008 Setup Wizard since I last installed a Katmai build. A couple items need...

Filed under: setup, 2008

My Variable doesn't like my Object any more - FIXED!

Published 13 May 8 3:11 PM | dougbert

THIS LIMITATION HAS BEEN FIXED AND REMOVED FOR SQL SERVER 2008 RTM. Object of any type can now be passed through package variables of type Object, and consumed within Script task code. No, wait. Maybe it's "My Object doesn't like my Variable...

Filed under: 2008, Script task, known issues