Browse by Tags

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

Published Mon, Jan 01 2009 5:32 PM by dougbert

Filed under: 2008, SAP

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

Published Tue, Jan 01 2009 4:42 PM by dougbert

Filed under: 2008, data profiling task

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

Published Mon, Jan 01 2009 3:04 PM by dougbert

Filed under: 2008, lookup

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

Published Mon, Nov 11 2008 5:11 PM by dougbert

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

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

Published Wed, Nov 11 2008 11:03 AM by dougbert

Filed under: 2008, lookup, cdc

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

Published Tue, Oct 10 2008 4:03 PM by dougbert

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

The first Integration Services 2008 book is now available

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

Published Thu, Oct 10 2008 3:53 PM by dougbert

Filed under: 2008, books

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

Published Tue, Aug 08 2008 8:42 AM by dougbert

Filed under: setup, 2008, known issues

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

Published Sat, Jul 07 2008 11:02 AM by dougbert

Filed under: 2008, Import and Export Wizard

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

Published Wed, Jul 07 2008 1:14 PM by dougbert

Filed under: setup, DTS, 2008

Not for use with the SendMail task!

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

Published Wed, Jun 06 2008 3:33 PM by dougbert

Filed under: 2008, off topic

Upgrading Custom Components for SQL Server 2008 Integration Services

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

Published Wed, Jun 06 2008 7:44 AM by dougbert

Filed under: 2008, custom components, upgrade

Adding a VSTA Script task programmatically (revised)

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

Published Sat, May 05 2008 8:55 AM by dougbert

Filed under: 2008, Script task, programming

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

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

Published Thu, May 05 2008 11:18 AM by dougbert

Filed under: setup, 2008

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

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

Published Tue, May 05 2008 3:11 PM by dougbert

Filed under: 2008, Script task, known issues

Go directly to . . .

Blog Search Form

Syndication

Tags

Dougbert Visitors

Archives