This topic has not yet been rated - Rate this topic

Working with Packages

SQL Server 2008 R2

SQL Server 2008

Use the topics in this section to learn more detailed information about how to use specific Integration Services components and how those components integrate with other SQL Server technologies.

In This Section

Improving the Performance of the Data Flow: Contains a series of suggestions to help you design packages that perform efficiently.
Profiling Data with the Data Profiling Task and Viewer: Describes how to use the Data Profiling task to learn about unfamiliar data sources and to discover potential problems in your data.
Improving Incremental Loads with Change Data Capture: In SQL Server, change data capture offers an effective solution to the challenge of efficiently performing incremental loads from source tables to data marts and data warehouses. The topics in this section describe how to create an Integration Services package that performs an incremental load of change data.
Using MERGE in Integration Services Packages: Describes how to use the Transact-SQL MERGE keyword, which is new in SQL Server 2008, in Integration Services.
Working with Other SQL Server Features: Describes the features of Integration Services that work with the SQL Server Database Engine, Analysis Services, and other major components of SQL Server.

Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Concepts

Designing and Implementing Packages (Integration Services)

Developer's Guide (Integration Services)

Integration Services Samples

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD