Export (0) Print
Expand All

Integration Services: New and Updated Topics (14 April 2006)

SQL Server 2005

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.

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

Arrow icon used with Back to Top link Back to Top

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

Arrow icon used with Back to Top link Back to Top

Community Additions

ADD
Show:
© 2014 Microsoft