Integration Services Information Worker InfoCenter prefix="o" ?>
In Microsoft SQL Server
2005 Integration Services (SSIS), a knowledge worker fulfills the traditional "domain
expert" role in business intelligence—someone who understands the data employed
by a solution and is able to translate the data into business information. Often,
the knowledge worker is the one analyzing the business to identify problems, opportunities,
or project characteristics. The variety in expertise offered by a knowledge worker
results in job titles such as Report Consumer (Business Analyst), Report Consumer
(Manager), Technical Trainer, Help Desk/Operation, or Network Administrator.
To help the knowledge
worker be as effective as possible, the following lists provide links to topics
concerning the design, creation, and configuration of Integration Services packages.
Integration Services
·
Integration Services Enhancements
Introducing Packages
·
Integration Services Packages
·
Integration Services Objects and Concepts
Creating Packages
·
Building Solutions and Integration Services Projects
·
Creating Packages in SSIS Designer
·
Creating Packages Using the SQL Server Import and Export
Wizard
Adding Features to Packages
·
Implementing Logging in Packages
·
Using Property Expressions in Packages
·
Creating Package Configurations
·
Using Checkpoints in Packages
·
Incorporating Transactions in Packages
Troubleshooting Packages
Deploying Packages
·
Deploying Integration Services Packages
Languages Used by Integration Services
·
Transact-SQL Reference (Transact-SQL)
·
Integration Services Expression Reference
Integration Services Developer InfoCenter
In Microsoft SQL Server
2005 Integration Services (SSIS), a developer designs and implements solutions based on the technology direction defined by the SSIS architect, the operational assistance
of the SSIS administrator, and the end-user feedback of the SSIS knowledge worker.
To these three sets of user groups, the title of SSIS developer may not be familiar.
These user groups may refer to their SSIS developer using job titles such as Application
Developer, Report Developer, ETL Developer, Data Warehouse Programmer, Database
Programmer, or Data Modeler.
To help the SSIS developer
be as effective as possible, the following lists provide links to a number of object
models and APIs for use in client-based and server-based applications.
SQL Server Integration Services
·
Integration Services Enhancements
Programming Integration Services
·
Integration Services Programming
·
Comparing Scripting Solutions and Custom Objects
Extending Packages with Scripting
·
Extending the Package with the Script Task
·
Extending the Data Flow with the Script Component
Extending Packages with Custom Objects
·
Creating a Custom Data Flow Component
Working with Packages Programmatically
·
Building Packages Programmatically
·
Enumerating Available Packages Programmatically
·
Managing Packages and Folders Programmatically
Running Packages from Other Applications
·
Understanding the Differences between Local and Remote
Execution
·
Loading and Running a Local Package Programmatically
·
Loading the Output of a Local Package
SQL Server Language Reference
·
Transact-SQL Reference (Transact-SQL)
·
Integration Services Expression Reference
·
Analysis Services Scripting Language (ASSL)
·
Data Mining Extensions (DMX) Reference
Programming Samples
·
SQL Server Integration Services Samples
Integration Services Object Model
·
Microsoft.SqlServer.Dts.Runtime
·
Microsoft.SqlServer.Dts.Pipeline
Integration Services Administrator InfoCenter
In Microsoft SQL Server
2005 Integration Services (SSIS), an administrator maintains and optimizes solutions
and projects at an operational level. Because these maintenance and optimization
tasks are wide ranging, an Integration Services administrator may be known by a
variety of job titles: Database Administrator, Report Server Administrator (Corporate
IT), Security Expert, Data Warehouse Administrator, or Lead Database Administrator.
To help the Integration
Services administrator be as effective as possible, the following lists provide
links to those topics considered most useful to the maintenance and optimization
of Integration Services solutions.
SQL Server Integration Services
·
Integration Services Enhancements
·
Integration Services Packages
Migrating Earlier Versions of Packages
·
SQL Server 2005 Integration Services Backward Compatibility
·
Migrating Data Transformation Services Packages
·
Using the Package Migration Wizard
Saving and Running Packages
·
Backing Up and Restoring Packages
·
Scheduling Package Execution in SQL Server Agent
·
Using Checkpoints in Packages
Monitoring Package Execution
·
Integration Services Service
·
Monitoring Integration Services Performance and Activity
Deploying Packages
·
Creating Package Configurations
·
Creating a Deployment Utility
