Integration Services: New and Updated Topics (17 July 2006)
New: 17 July 2006
In the 17 July 2006 release of SQL Server Books Online, the following topics have either been added or updated.
Topic Categories
New Conceptual and Task Topics
Updated Conceptual and Task Topics
Updated Managed Reference Topics
New Conceptual and Task Topics
Concepts
Connecting to a Remote Integration Services Server
How to: Connect to a dBASE or Other DBF File
Programming
Managing Package Roles Programmatically
Managing Packages Programmatically
Managing Running Packages Programmatically
Understanding Synchronous and Asynchronous Transformations
Updated Conceptual and Task Topics
Concepts
Creating Packages Using the SQL Server Import and Export Wizard
How to: Loop through Excel Files and Tables
How to: Modify a Connection Manager
How to: Set Container Properties
How to: Start the SQL Server Import and Export Wizard
Integration Services Architecture
Integration Services Data Types
SQL Server Import and Export Wizard Enhancements
Troubleshooting Integration Services
Troubleshooting Package Development
Troubleshooting Package Execution
Troubleshooting Package Performance
Troubleshooting the Integration Services Service
Programmability
Adding Connections Programmatically
Adding Data Flow Components Programmatically
Adding the Data Flow Task Programmatically
Connecting Tasks Programmatically
Creating a Destination with the Script Component
Creating a Source with the Script Component
Creating a Synchronous Transformation with the Script Component
Creating an Asynchronous Transformation with the Script Component
Creating an ODBC Destination with the Script Component
Enhancing an Error Output with the Script Component
Handling Events Programmatically
Integration Services Programming Architecture
Parsing Non-Standard Text File Formats with the Script Component
Selecting Input Columns Programmatically