Integration Services: New and Updated Topics (14 April 2006)
New: 14 April 2006
In the 14 April 2006 release of SQL Server Books Online, the following topics have either been added to Books Online or have had significant changes.
Topic Categories
New Conceptual and Task Topics
Updated Conceptual and Task Topics
Updated Managed Reference Topics
New Conceptual and Task Topics
Building, Deploying, and Debugging Custom Objects
Coding a Custom Log Provider
Creating a Custom Connection Manager
Deprecated Features in SQL Server 2005 Integration Services
Developing a Custom ForEach Enumerator
Developing a User Interface for a Custom Log Provider
Developing Custom Objects for Integration Services
Enumerating Available Packages Programmatically
How to: Implement a Signing Policy Using a Registry Value
How to: Use Data Source Views in Packages
How to: View Packages in the Package Store Using SQL Server Management Studio
Understanding the Differences between Local and Remote Execution
Integration Services Programming Architecture
Loading and Running a Remote Package Programmatically
Managing Packages and Folders Programmatically
Persisting Custom Objects
Saving a Package Programmatically
Sending an HTML Mail Message with the Script Task
Sending to a Remote Private Message Queue with the Script Task
Using Integration Services with Analysis Services
Using Integration Services with Data Mining
Using Integration Services with Other Applications
Using Integration Services with Other SQL Server Features
Using Integration Services with SQL Server Compact Edition
Using Integration Services with the Database Engine
Working with Excel Files with the Script Task
Back to Top
Updated Conceptual and Task Topics
Coding and Debugging the Script Component
Coding and Debugging the Script Task
Common Properties
Configuring the Integration Services Service
Creating a Custom Task
Creating a Synchronous Transformation with the Script Component
Creating an Asynchronous Transformation with the Script Component
Creating Packages Using the SQL Server Import and Export Wizard
Data Flow Task
DataReader Source
Debugging Script
Derived Column Transformation
Design-time Methods of a Data Flow Component
Destination Custom Properties
Developing a Custom Destination Component
Developing a Custom Source Component
Developing a User Interface for a Custom Task
File System Task
Flat File Source
Gathering a List for the ForEach Loop with the Script Task
How to: Derive Column Values Using the Derived Column Transformation
How to: Loop through Excel Files and Tables
How to: Run a Package Using a SQL Server Agent Job
How to: Save a Copy of a Package
How to: Set Precedence Constraint Properties in the Properties Window
Integration Services Containers
Integration Services Programming
Loading the Output of a Local Package
Logging in the Script Task
Lookup Transformation
Maintenance Cleanup Task
Managing Integration Services Packages
Monitoring Performance Counters with the Script Task
Package Configurations
Package Samples
Parsing Non-Standard Text File Formats with the Script Component
Pivot Transformation
Raising Events in the Script Task
Raw File Destination
Send Mail Task
Signing Packages with Certificates
Transfer Database Task
Unpivot Transformation
Using Checkpoints in Packages
Connecting to Data Sources in the Script Task
Using Data Source Views in Packages
Using Data Sources in Packages
Referencing Other Assemblies in Scripting Solutions
Using Queries in Packages
Using Variables in Packages
Using Variables in the Script Task
Web Service Task
XML Source
Back to Top
Updated Managed Reference Topics
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASExecuteDDLTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASExecuteDDLTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.ManagedConnections.MSMQConn.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.ManagedConnections.MSMQConn.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.ManagedConnections.SMOServerConn.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.ManagedConnections.SMOServerConn.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.ManagedConnections.SMTPConn.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.ManagedConnections.SMTPConn.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.ManagedConnections.WMIConn.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.ManagedConnections.WMIConn.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Pipeline.Design.IDtsComponentUI.Initialize(Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData90,System.IServiceProvider)
Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.DirectRow(System.Int32)
Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSRuntimeComponent90.PerformUpgrade(System.Int32)
Microsoft.SqlServer.Dts.Runtime.Configuration.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.Configuration.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.ConnectionManager.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.ConnectionManager.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.Connections.Add(System.String)
Microsoft.SqlServer.Dts.Runtime.DtsContainer.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.DtsContainer.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumerator.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumerator.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachSchemaRowsetEnumerator.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachSchemaRowsetEnumerator.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Runtime.Enumerators.SMO.ForEachSMOEnumerator.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Runtime.Enumerators.SMO.ForEachSMOEnumerator.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Runtime.ExtendedProperty.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.ExtendedProperty.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.FlatFileColumn.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.FlatFileColumn.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.ForEachEnumeratorHost.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.ForEachEnumeratorHost.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.ForEachVariableMapping.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.ForEachVariableMapping.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.FtpClientConnection.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.FtpClientConnection.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.HttpClientConnection.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.HttpClientConnection.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Runtime.IDTSPersist.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.IDTSPersist.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.LoggingOptions.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.LoggingOptions.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.LogProvider.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.LogProvider.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.PrecedenceConstraint.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.PrecedenceConstraint.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.Variable.LoadFromXML(System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Runtime.Variable.SaveToXML(System.Xml.XmlDocument,System.Xml.XmlNode,Microsoft.SqlServer.Dts.Runtime.IDTSEvents)
Microsoft.SqlServer.Dts.Tasks.ActiveXScriptTask.ActiveXScriptTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.ActiveXScriptTask.ActiveXScriptTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.DMQueryTask.DMQueryTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.DMQueryTask.DMQueryTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.ExecuteProcess.ExecuteProcess.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.ExecuteProcess.ExecuteProcess.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.FtpTask.FtpTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.FtpTask.FtpTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.SendMailTask.SendMailTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.SendMailTask.SendMailTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask.TransferDatabaseTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask.TransferDatabaseTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferErrorMessagesTask.TransferErrorMessagesTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferErrorMessagesTask.TransferErrorMessagesTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferJobsTask.TransferJobsTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferJobsTask.TransferJobsTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferLoginsTask.TransferLoginsTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferLoginsTask.TransferLoginsTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask.TransferSqlServerObjectsTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask.TransferSqlServerObjectsTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask.TransferStoredProceduresTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask.TransferStoredProceduresTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask.WmiDataReaderTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask.WmiDataReaderTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.WmiEventWatcherTask.WmiEventWatcherTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.WmiEventWatcherTask.WmiEventWatcherTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.XMLTask.XMLTask.LoadFromXML(System.Xml.XmlElement,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Tasks.XMLTask.XMLTask.SaveToXML(System.Xml.XmlDocument,Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents)
Microsoft.SqlServer.Dts.Runtime.DtsLogProviderAttribute.LogProviderType
Microsoft.SqlServer.Dts.Runtime.DtsTaskAttribute.TaskType
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.Location
Microsoft.SqlServer.Dts.Tasks.ExecutePackageTask.ExecutePackageTaskClass.ExecuteOutOfProcess
Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask.EncryptionAlgo
Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask.UseEncryption
Microsoft.SqlServer.Dts.Runtime.DtsLogProviderAttribute
Microsoft.SqlServer.Dts.Runtime.DtsTaskAttribute
Microsoft.SqlServer.Dts.Runtime.VariableDispenser
Microsoft.SqlServer.Dts.Runtime.Variables
Microsoft.SqlServer.Dts.Tasks.MessageQueueTask.MessageQueueTask
Back to Top