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.
Objects and Concepts
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
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
Security
How to: Implement a Signing Policy Using a Registry Value
Protecting Access to Running Packages
Programming
Tutorials
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)
