Integration Services:新增和更新的主題 (2006 年 4 月 14 日)
新增: 2006 年 4 月 14 日
在《SQL Server 線上叢書》的 2006 年 4 月 14 日 版本中,下列主題均已加入線上叢書或進行了重大變更。
主題類別目錄
新增的概念和工作主題
更新的概念和工作主題
更新的 Managed 參考主題
新增的概念和工作主題
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
如何:使用登錄值實作簽署原則
How to:在封裝中使用資料來源檢視
如何:使用 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 和 Database Engine
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 Agent 作業執行封裝
如何:儲存封裝的副本
如何:在屬性視窗中設定優先順序條件約束屬性
整合服務容器
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 來源
回到頁首
更新的 Managed 參考主題
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
回到頁首