Integration Services:新的和已更新的主题(2006 年 4 月 14 日)
新建日期: 2006 年 4 月 14 日
在 2006 年 4 月 14 日 版本的 SQL Server 联机丛书中,联机丛书中添加了以下主题或进行了重要更改。
主题类别
新的概念性和任务主题
更新的概念性和任务主题
更新的托管参考主题
新的概念性和任务主题
Building, Deploying, and Debugging Custom Objects
Coding a Custom Log Provider
Creating a Custom Connection Manager
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
如何使用注册表值实现签名策略
如何在包中使用数据源视图
如何使用 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
将 Integration Services 与 Analysis Services 结合使用
将 Integration Services 与数据挖掘一起使用
将 Integration Services 与其他应用程序结合使用
将 Integration Services 与其他 SQL Server 功能一起使用
将 Integration Services 与 SQL Server Compact Edition 结合使用
将 Integration Services 与数据库引擎一起使用
Working with Excel Files with the Script Task
返回页首
更新的概念性和任务主题
Coding and Debugging the Script Component
Coding and Debugging the Script Task
Common Properties
配置 Integration Services 服务
Creating a Custom Task
Creating a Synchronous Transformation with the Script Component
Creating an Asynchronous Transformation with the Script Component
使用 SQL Server 导入和导出向导创建包
数据流任务
DataReader 源
调试脚本
派生列转换
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
文件系统任务
平面文件源
Gathering a List for the ForEach Loop with the Script Task
如何使用派生列转换派生列值
如何循环遍历 Excel 文件和表
如何使用 SQL Server 代理作业运行包
如何保存包的副本
如何在“属性”窗口中设置优先约束属性
Integration Services 容器
Integration Services Programming
Loading the Output of a Local Package
Logging in the Script Task
查找转换
“清除维护”任务
管理 Integration Services 包
Monitoring Performance Counters with the Script Task
包配置
包示例
Parsing Non-Standard Text File Formats with the Script Component
透视转换
Raising Events in the Script Task
原始文件目标
发送邮件任务
使用证书对包进行签名
传输数据库任务
逆透视转换
在包中使用检查点
Connecting to Data Sources in the Script Task
使用包中的数据源视图
在包中使用数据源
Referencing Other Assemblies in Scripting Solutions
在包中使用查询
在包中使用变量
Using Variables in the Script Task
Web 服务任务
XML 源
返回页首
更新的托管参考主题
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
返回页首