Integration Services: New and Updated Topics (1 February 2007)
In the 12 December 2006 release of SQL Server Books Online, the following topics have either been added or updated.
The topics listed here not only include corrections or clarifications, but also descriptions of the following new features in Microsoft SQL Server 2005 Service Pack 2 (SP2):
- New logging messages that provide enhanced troubleshooting support for connections to external data providers. For more information, see Troubleshooting Package Execution.
- Support for Microsoft Office Access 2007 databases and Office Excel 2007 spreadsheets in the OLE DB connection manager, source, and destination.
Topic Categories
Updated Conceptual and Task Topics
Updated Managed Reference Topics
Updated Conceptual and Task Topics
Objects and Concepts
Slowly Changing Dimension Transformation
Transformation Custom Properties
Back to Top
Working with Packages and Projects
Creating Packages Using the SQL Server Import and Export Wizard
How to: Remove an Integration Services Project from a Solution
Troubleshooting Package Execution
Back to Top
Installation and Administration
Command Prompt Utilities (SSIS)
Configuring the Integration Services Service
How to: Add Integration Services to an Existing Instance of SQL Server 2005
How to: View Packages in the Package Store Using SQL Server Management Studio
Back to Top
Security
How to: Implement a Signing Policy Using a Registry Value
Protecting Access to Running Packages
Signing Packages with Certificates
Back to Top
Programming
Working with Variables Programmatically
Back to Top
Tutorials
Adding a Flat File Destination
Enabling and Configuring Package Configurations
Back to Top
F1 Help
Choose a Data Source (SQL Server Import and Export Wizard)
Choose a Destination (SQL Server Import and Export Wizard)
Configure OLE DB Connection Manager
Excel Connection Manager Editor
Excel Destination Editor (Connection Manager Page)
Excel Source Editor (Connection Manager Page)
Lookup Transformation Editor (Advanced Tab)
Lookup Transformation Editor (Reference Table Tab)
OLE DB Destination Editor (Connection Manager Page)
OLE DB Source Editor (Connection Manager Page)
Select Objects to Export (Package Configuration Wizard)
Back to Top
Updated Managed Reference Topics
Back to Top
See Also
Concepts
New and Updated Books Online Topics (1 February 2007)
Integration Services: New and Updated Topics (17 July 2006)
Integration Services: New and Updated Topics (14 April 2006)
What's New in SQL Server 2005 SP2