Sync Your Database to SharePoint Using SSIS

Discover how to import and export SharePoint list items using SQL Server Integration Services and the new Collaborative Application Markup Language (CAML).

How to Choose the Best Connectors for SSIS

What types of connectors make the most sense for SSIS packages? New author Mike Frost brings us a look at the various options along with some recommendations for different types of data as well as the 64-bit platform.

You want to implement a fast parse of...

Accessing .NET assemblies with SSIS

SQL Server Integration Services has changed the ETL process dramatically with many new capabilities. It's extensibility is unmatched, allowing you to build workflows that were not possible in DTS. Dinesh Priyankara brings us a useful new technique for referencing your .NET assemblies from within SSIS to take advantage of code reuse.

You are building an SQL Server 2005 Integration...

Making SQL Server 2005 Integration Services Packages Portable

SSIS introduced a feature called "Package Configurations". Package configurations allow us to make SSIS packages portable and help us change SQL Server and file connectivity information dynamically.

Using Fuzzy Lookups for Record Linkage

SQL Server Integration Services (SSIS) includes two very interesting transforms, the Fuzzy Grouping and Fuzzy Lookup transformations. Brian Norberg discussed the former in another article and this time examines the Fuzzy Lookup Transformation.

Finding Similar Data Using SQL Server Integration Services

SQL Server 2005 has greatly increased the capabilities of the platform and brought the capabilities for complex ETL packages to many businesses at an affordable cost. One of the very interesting transformations you can use in SSIS is the fuzzy grouping task and new author Brian Nordberg brings us a look at how you can use this.

When using the Fuzzy Grouping transformation, how can...

SSIS Stumpers V1 - Unpivot Example

In this series, Brian Knight shows you an actual difficult business problem to solve, gives you hints about how to solve it and then lastly shows you step-by-step instructions how to solve it if you want the help. n this video of the series, Brian demonstrate how to unpivot data that may arrive from the mainframe and load a many to many table with SSIS.