SQL Server TechCenter
Click to Rate and Give Feedback

SQL Server 2008 – Integration Services

 

Go to SQL Server 2005 Integration Services

 

Get Help

Search SQL Server 2008 documentation, articles, and videos.

 

Browse Books Online: 2008 | 2005 | 2000

Ask in Forum | Ask Support | Search the Knowledge Base

 

Get Started


Product Overview:White Paper: Introduction to SQL Server 2008 Integration Services | SQL Server 2008 Integration Services Datasheet
Tutorials:Tutorial: Creating a Simple ETL Package | Tutorial: Creating a Basic Package Using a Wizard
Videos:Creating a Basic Package | More Videos...
Other Online Training:Videos on JumpstartTV | Training Videos at LearnIntegrationServices.com

Recent Microsoft Downloads and Resources

How Do I: Import Text Files with SQL Server Integration Services?
How Do I: Import Text Files with SQL Server Integration Services?
See this video from Scott Golightly and learn how to use SQL Server Integration Services to import text files into SQL Server.
How Do I: Import Data from Oracle Databases?
How Do I: Import Data from Oracle Databases?
Want to use SSIS to import data from an Oracle database into a SQL Server database? Find out how in this video from Scott Golightly.
How Do I: Profile Data with the Data Profiling Task and Viewer
How Do I: Profile Data with the Data Profiling Task and Viewer
Use Scott Golightly's video to learn how to use the Data Profiling task in SQL Server Integration Services to profile data.
Microsoft SQL Server 2008 Books Online (January 2009)
Microsoft SQL Server 2008 Books Online (January 2009)
Microsoft Connectors for Oracle and Teradata by Attunity
Microsoft Connectors for Oracle and Teradata by Attunity
Microsoft Connector 1.0 for SAP BI (October Feature Pack)
Microsoft Connector 1.0 for SAP BI (October Feature Pack)
Provide an Up-to-Date Data Warehouse with Change Data Capture
Provide an Up-to-Date Data Warehouse with Change Data Capture
Watch this video from Scott Golightly to learn to configure the Change Data Capture feature in SQL Server 2008, and extract that data using a SSIS package.

More downloads and resources...

Community Buzz

Logging connection strings
Logging connection strings
Follow this suggestion from MVP Darren Green and use the log file to save all the connections that your package uses.
Facilitating a Delta Refresh with SSIS Using the T-SQL MERGE Statement
Facilitating a Delta Refresh with SSIS Using the T-SQL MERGE Statement
Follow consultant Duane Douglas’s steps on how to use the new MERGE statement to import only new and changed rows.
Scripts and assembly caching in 2005
Scripts and assembly caching in 2005
Look at Developer Matt Masson's explanation of how the product team fixed unexpected problems with scripts in SQL Server 2005.
Converting Your Script Task Into a Custom Task, Part I - Why?
Converting Your Script Task Into a Custom Task, Part I - Why?
Read Todd McDermid's posting and find out the advantages of converting the code in your script into a custom task.
Dimension ETL from One Source Table
Dimension ETL from One Source Table
Read how MVP Jessica Moss solves the real-world problem where all dimensions and facts come from a single large source table.
Creating packages in code – Execute SQL Task
Creating packages in code – Execute SQL Task
Configure an Execute SQL task programmatically by using this sample code form MVP Darren Green.

More community...

MVP Focus

Rushabh Mehta is a Mentor for Solid Quality Mentors’ global Business Intelligence division, and Managing Director for Solid Quality India Pvt. Ltd. More about Rushabh…

 

More team members and MVPs…

Product Overview
 

Downloads

More downloads…

 

Articles

SQL Server Customer Advisory Team (SQLCAT)

Microsoft White Papers

Community Articles (MSDN Library)

 

Videos

 

Code Samples and Public Projects

Microsoft Product Team Samples

Community Samples

Search

 

Web Sites

  • http://ssis.wik.is/

    The Integration Services wiki, where Microsoft and customers share information about connectivity

  • sqlis.com

    Site of SQL Server MVPs, Darren Green and Allan Mitchell, who specialize in Integration Services

  • MSSQLTips.com

    Site search for Integration Services tips.

 

Podcasts and Webcasts

 

Books

Microsoft Team Blogs

MVP Blogs

Page view tracker