帖子的附录

81 阅读 0 评论 54 点赞

我是靠谱客的博主暴躁小猫咪，最近开发中收集的这篇文章主要介绍帖子的附录，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

http://topic.csdn.net/u/20110306/12/d7f15ec3-cdee-4ddc-bce9-74f09011ed98.html

附录1：

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message OnPreValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:19,2011-3-6 12:17:19,0,0x,(null) OnPreValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:19,2011-3-6 12:17:19,0,0x,(null) OnPostValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:19,2011-3-6 12:17:19,0,0x,(null) OnPostValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:19,2011-3-6 12:17:19,0,0x,(null) PackageStart,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:20,2011-3-6 12:17:20,0,0x,包执行开始。 Diagnostic,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:20,2011-3-6 12:17:20,0,0x,最大并发可执行文件数目被设置为 1。 OnPreExecute,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:20,2011-3-6 12:17:20,0,0x,(null) OnPreExecute,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:20,2011-3-6 12:17:20,0,0x,(null) OnPreValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:20,2011-3-6 12:17:20,0,0x,(null) OnPostValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:20,2011-3-6 12:17:20,0,0x,(null) OnProgress,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:20,2011-3-6 12:17:20,0,0x,任务刚刚开始执行。 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:20,2011-3-6 12:17:20,0,0x,正在连接到服务器 WPF-PC3 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:20,2011-3-6 12:17:20,0,0x,正在连接到服务器 WPF-PC3 OnError,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:21,2011-3-6 12:17:21,0,0x,无法连接到服务器 WPF-PC3。 StackTrace: at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp) InnerException-->用户 'NT AUTHORITY/ANONYMOUS LOGON' 登录失败。 StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity) at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() OnError,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:21,2011-3-6 12:17:21,0,0x,无法连接到服务器 WPF-PC3。 StackTrace: at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp) InnerException-->用户 'NT AUTHORITY/ANONYMOUS LOGON' 登录失败。 StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity) at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() OnProgress,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:21,2011-3-6 12:17:21,100,0x,传输对象执行完毕。 OnTaskFailed,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:21,2011-3-6 12:17:21,0,0x,(null) OnPostExecute,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{263BB619-DFC2-47C3-A752-E5210440038B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:21,2011-3-6 12:17:21,0,0x,(null) OnWarning,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:21,2011-3-6 12:17:21,-2147381246,0x,SSIS 警告代码 DTS_W_MAXIMUMERRORCOUNTREACHED。Execution 方法成功，但出现的错误数(1)达到了允许的最大值(1)，因此导致失败。当错误数达到 MaximumErrorCount 中指定的数目时将发生这种情况。请更改 MaximumErrorCount 或纠正这些错误。 OnPostExecute,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:21,2011-3-6 12:17:21,0,0x,(null) PackageEnd,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_14,{758C4977-6E52-45CF-9C72-F7497F34F21B},{55AD8DC1-4B5C-48BC-AB4D-334EFE0A3371},2011-3-6 12:17:21,2011-3-6 12:17:21,1,0x,包执行结束。

附录2：

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message OnPreValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,(null) OnPreValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,(null) OnPostValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,(null) OnPostValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,(null) PackageStart,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,包执行开始。 Diagnostic,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,最大并发可执行文件数目被设置为 1。 OnPreExecute,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,(null) OnPreExecute,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,(null) OnPreValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,(null) OnPostValidate,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,(null) OnProgress,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,任务刚刚开始执行。 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,正在连接到服务器 WPF-PC3 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:35,2011-3-6 12:27:35,0,0x,正在连接到服务器 WPF-PC3 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:39,2011-3-6 12:27:39,0,0x,已连接到服务器 WPF-PC3 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:39,2011-3-6 12:27:39,0,0x,已连接到服务器 WPF-PC3 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:39,2011-3-6 12:27:39,0,0x,正在连接到服务器 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:39,2011-3-6 12:27:39,0,0x,正在连接到服务器 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:39,2011-3-6 12:27:39,0,0x,已连接到服务器 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:39,2011-3-6 12:27:39,0,0x,已连接到服务器 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,正在将服务器对象从 WPF-PC3 传输到服务器 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,正在将服务器对象从 WPF-PC3 传输到服务器 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,正在将服务器对象从 WPF-PC3 传输到服务器 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,正在将服务器对象从 WPF-PC3 传输到服务器 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,目标服务器中已存在登录名 ##MS_PolicyEventProcessingLogin##，因此将不传输该登录名。 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,目标服务器中已存在登录名 ##MS_PolicyEventProcessingLogin##，因此将不传输该登录名。 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,目标服务器中已存在登录名 WPF-SERVER1/SystemAdmin，因此将不传输该登录名。 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,目标服务器中已存在登录名 WPF-SERVER1/SystemAdmin，因此将不传输该登录名。 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,(null) OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,(null) OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,已将服务器对象传输到 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,已将服务器对象传输到 WPF-SERVER1 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,将数据库 TestDB 从 WPF-PC3 服务器作为 TestDB 传输到 WPF-SERVER1 服务器 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,将数据库 TestDB 从 WPF-PC3 服务器作为 TestDB 传输到 WPF-SERVER1 服务器 OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,已将路径 D:/Program Files/Microsoft SQL Server/MSSQL10_50.MSSQLSERVER/MSSQL/DATA/TestDB.mdf 中的数据文件 TestDB 添加到文件组 [PRIMARY] OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,已将路径 D:/Program Files/Microsoft SQL Server/MSSQL10_50.MSSQLSERVER/MSSQL/DATA/TestDB.mdf 中的数据文件 TestDB 添加到文件组 [PRIMARY] OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,已添加路径 D:/Program Files/Microsoft SQL Server/MSSQL10_50.MSSQLSERVER/MSSQL/DATA/TestDB_log.ldf 中的日志文件 TestDB_log OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,已添加路径 D:/Program Files/Microsoft SQL Server/MSSQL10_50.MSSQLSERVER/MSSQL/DATA/TestDB_log.ldf 中的日志文件 TestDB_log OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,正在将数据从 TestDB 传输到数据库 TestDB OnInformation,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:40,2011-3-6 12:27:40,0,0x,正在将数据从 TestDB 传输到数据库 TestDB OnError,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:47,2011-3-6 12:27:47,0,0x,错误: errorCode=-1073548784 description=执行查询“EXEC dbo.sp_changedbowner @loginame = N'WPF-PC3/Sy...”失败，错误如下:“无法对主体 'WPF-PC3/SystemAdmin' 执行查找，因为它不存在，或者您没有所需的权限。”。失败的原因可能有: 查询本身有问题、未正确设置 "ResultSet" 属性、未正确设置参数或未正确建立连接。 helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C} StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer() at Microsoft.SqlServer.Management.Smo.Transfer.TransferData() at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer() OnError,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:47,2011-3-6 12:27:47,0,0x,错误: errorCode=-1073548784 description=执行查询“EXEC dbo.sp_changedbowner @loginame = N'WPF-PC3/Sy...”失败，错误如下:“无法对主体 'WPF-PC3/SystemAdmin' 执行查找，因为它不存在，或者您没有所需的权限。”。失败的原因可能有: 查询本身有问题、未正确设置 "ResultSet" 属性、未正确设置参数或未正确建立连接。 helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C} StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer() at Microsoft.SqlServer.Management.Smo.Transfer.TransferData() at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer() OnProgress,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:47,2011-3-6 12:27:47,0,0x,1 个数据库的数据库传输失败。 OnProgress,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:47,2011-3-6 12:27:47,100,0x,传输对象执行完毕。 OnTaskFailed,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:47,2011-3-6 12:27:47,0,0x,(null) OnPostExecute,WPF-SERVER1,NT AUTHORITY/SYSTEM,WPF-PC3_WPF-SERVER1_Transfer 对象任务,{DD120D79-556E-4067-900C-A9FD64D62947},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:47,2011-3-6 12:27:47,0,0x,(null) OnWarning,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:47,2011-3-6 12:27:47,-2147381246,0x,SSIS 警告代码 DTS_W_MAXIMUMERRORCOUNTREACHED。Execution 方法成功，但出现的错误数(1)达到了允许的最大值(1)，因此导致失败。当错误数达到 MaximumErrorCount 中指定的数目时将发生这种情况。请更改 MaximumErrorCount 或纠正这些错误。 OnPostExecute,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:47,2011-3-6 12:27:47,0,0x,(null) PackageEnd,WPF-SERVER1,NT AUTHORITY/SYSTEM,CDW_WPF-PC3_WPF-SERVER1_17,{EE6A1892-CCB6-44EA-B107-B8206A43CD1E},{D5D986C6-B311-4BB5-BF52-8C9E1BFD207B},2011-3-6 12:27:47,2011-3-6 12:27:47,1,0x,包执行结束。