asked on
Execute SQL Server Agent Job Error Continued

The SSIS fails at the end,
Log Name:      Application
Source:        SQLSERVERAGENT
Date:          30/07/2010 2:14:29 PM
Event ID:      208
Task Category: Job Engine
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      WIN-APWS2K38OMK
Description:
SQL Server Scheduled Job 'CDW_271029-WEB1_WIN-APWS2K38OMK_1' (0x2994590E61B10744B1A1119FEF91700F) - Status: Failed - Invoked on: 2010-07-30 13:31:36 - Message: The job failed.  The Job was invoked by User sa.  The last step to run was step 1 (CDW_271029-WEB1_WIN-APWS2K38OMK_1_Step).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLSERVERAGENT" />
    <EventID Qualifiers="16384">208</EventID>
    <Level>3</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:29.000Z" />
    <EventRecordID>3329</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security />
  </System>
  <EventData>
    <Data>CDW_271029-WEB1_WIN-APWS2K38OMK_1</Data>
    <Data>0x2994590E61B10744B1A1119FEF91700F</Data>
    <Data>Failed</Data>
    <Data>2010-07-30 13:31:36</Data>
    <Data>The job failed.  The Job was invoked by User sa.  The last step to run was step 1 (CDW_271029-WEB1_WIN-APWS2K38OMK_1_Step).</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12291
Task Category: None
Level:         Error
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
Package "CDW_271029-WEB1_WIN-APWS2K38OMK_1" failed.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16385">12291</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3328</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>CDW_271029-WEB1_WIN-APWS2K38OMK_1</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12557
Task Category: None
Level:         Information
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
  Event Name: PackageEnd
 Message: End of package execution.

 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: CDW_271029-WEB1_WIN-APWS2K38OMK_1
 Source ID: {D89136F0-2108-4B63-85F7-3C0DDD8A541A}
 Execution ID: {21859E1F-5F28-4A04-9E5A-5D94A629A13C}
 Start Time: 30/07/2010 2:14:27 PM
 End Time: 30/07/2010 2:14:27 PM
 Data Code: 1
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16400">12557</EventID>
    <Level>4</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3327</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>PackageEnd</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>CDW_271029-WEB1_WIN-APWS2K38OMK_1</Data>
    <Data>{D89136F0-2108-4B63-85F7-3C0DDD8A541A}</Data>
    <Data>{21859E1F-5F28-4A04-9E5A-5D94A629A13C}</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>1</Data>
    <Data>End of package execution.
</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12546
Task Category: None
Level:         Information
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
  Event Name: OnPostExecute
 Message: 
 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: CDW_271029-WEB1_WIN-APWS2K38OMK_1
 Source ID: {D89136F0-2108-4B63-85F7-3C0DDD8A541A}
 Execution ID: {21859E1F-5F28-4A04-9E5A-5D94A629A13C}
 Start Time: 30/07/2010 2:14:27 PM
 End Time: 30/07/2010 2:14:27 PM
 Data Code: 0
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16400">12546</EventID>
    <Level>0</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3326</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>OnPostExecute</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>CDW_271029-WEB1_WIN-APWS2K38OMK_1</Data>
    <Data>{D89136F0-2108-4B63-85F7-3C0DDD8A541A}</Data>
    <Data>{21859E1F-5F28-4A04-9E5A-5D94A629A13C}</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>0</Data>
    <Data>
    </Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12549
Task Category: None
Level:         Warning
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
  Event Name: OnWarning
 Message: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: CDW_271029-WEB1_WIN-APWS2K38OMK_1
 Source ID: {D89136F0-2108-4B63-85F7-3C0DDD8A541A}
 Execution ID: {21859E1F-5F28-4A04-9E5A-5D94A629A13C}
 Start Time: 30/07/2010 2:14:27 PM
 End Time: 30/07/2010 2:14:27 PM
 Data Code: -2147381246
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16400">12549</EventID>
    <Level>3</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3325</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>OnWarning</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>CDW_271029-WEB1_WIN-APWS2K38OMK_1</Data>
    <Data>{D89136F0-2108-4B63-85F7-3C0DDD8A541A}</Data>
    <Data>{21859E1F-5F28-4A04-9E5A-5D94A629A13C}</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>-2147381246</Data>
    <Data>SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12546
Task Category: None
Level:         Information
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
  Event Name: OnPostExecute
 Message: 
 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: 173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task
 Source ID: {B9BA203A-1400-467F-9A26-E9104B66198B}
 Execution ID: {21859E1F-5F28-4A04-9E5A-5D94A629A13C}
 Start Time: 30/07/2010 2:14:27 PM
 End Time: 30/07/2010 2:14:27 PM
 Data Code: 0
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16400">12546</EventID>
    <Level>0</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3324</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>OnPostExecute</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task</Data>
    <Data>{B9BA203A-1400-467F-9A26-E9104B66198B}</Data>
    <Data>{21859E1F-5F28-4A04-9E5A-5D94A629A13C}</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>0</Data>
    <Data>
    </Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12551
Task Category: None
Level:         Error
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
  Event Name: OnTaskFailed
 Message: 
 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: 173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task
 Source ID: {B9BA203A-1400-467F-9A26-E9104B66198B}
 Execution ID: {21859E1F-5F28-4A04-9E5A-5D94A629A13C}
 Start Time: 30/07/2010 2:14:27 PM
 End Time: 30/07/2010 2:14:27 PM
 Data Code: 0
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16400">12551</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3323</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>OnTaskFailed</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task</Data>
    <Data>{B9BA203A-1400-467F-9A26-E9104B66198B}</Data>
    <Data>{21859E1F-5F28-4A04-9E5A-5D94A629A13C}</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>0</Data>
    <Data>
    </Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12552
Task Category: None
Level:         Information
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
  Event Name: OnProgress
 Message: Transfer objects finished execution.
 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: 173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task
 Source ID: {B9BA203A-1400-467F-9A26-E9104B66198B}
 Execution ID: {21859E1F-5F28-4A04-9E5A-5D94A629A13C}
 Start Time: 30/07/2010 2:14:27 PM
 End Time: 30/07/2010 2:14:27 PM
 Data Code: 100
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16400">12552</EventID>
    <Level>4</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3322</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>OnProgress</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task</Data>
    <Data>{B9BA203A-1400-467F-9A26-E9104B66198B}</Data>
    <Data>{21859E1F-5F28-4A04-9E5A-5D94A629A13C}</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>100</Data>
    <Data>Transfer objects finished execution.</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12552
Task Category: None
Level:         Information
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
  Event Name: OnProgress
 Message: Database transfer failed for 1 database(s).
 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: 173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task
 Source ID: {B9BA203A-1400-467F-9A26-E9104B66198B}
 Execution ID: {21859E1F-5F28-4A04-9E5A-5D94A629A13C}
 Start Time: 30/07/2010 2:14:27 PM
 End Time: 30/07/2010 2:14:27 PM
 Data Code: 0
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16400">12552</EventID>
    <Level>4</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3321</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>OnProgress</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task</Data>
    <Data>{B9BA203A-1400-467F-9A26-E9104B66198B}</Data>
    <Data>{21859E1F-5F28-4A04-9E5A-5D94A629A13C}</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>0</Data>
    <Data>Database transfer failed for 1 database(s).</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12550
Task Category: None
Level:         Error
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
  Event Name: OnError
 Message: ERROR : errorCode=-1073548784 description=Executing the query "CREATE USER [oneworldunited] FOR LOGIN [oneworldun..." failed with the following error: "'oneworldunited' is not a valid login or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
 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()
 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: CDW_271029-WEB1_WIN-APWS2K38OMK_1
 Source ID: {D89136F0-2108-4B63-85F7-3C0DDD8A541A}
 Execution ID: {21859E1F-5F28-4A04-9E5A-5D94A629A13C}
 Start Time: 30/07/2010 2:14:27 PM
 End Time: 30/07/2010 2:14:27 PM
 Data Code: 0
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16400">12550</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3320</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>OnError</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>CDW_271029-WEB1_WIN-APWS2K38OMK_1</Data>
    <Data>{D89136F0-2108-4B63-85F7-3C0DDD8A541A}</Data>
    <Data>{21859E1F-5F28-4A04-9E5A-5D94A629A13C}</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>0</Data>
    <Data>ERROR : errorCode=-1073548784 description=Executing the query "CREATE USER [oneworldunited] FOR LOGIN [oneworldun..." failed with the following error: "'oneworldunited' is not a valid login or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
 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()</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12550
Task Category: None
Level:         Error
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
  Event Name: OnError
 Message: ERROR : errorCode=-1073548784 description=Executing the query "CREATE USER [oneworldunited] FOR LOGIN [oneworldun..." failed with the following error: "'oneworldunited' is not a valid login or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
 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()
 Operator: NT AUTHORITY\NETWORK SERVICE
 Source Name: 173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task
 Source ID: {B9BA203A-1400-467F-9A26-E9104B66198B}
 Execution ID: {21859E1F-5F28-4A04-9E5A-5D94A629A13C}
 Start Time: 30/07/2010 2:14:27 PM
 End Time: 30/07/2010 2:14:27 PM
 Data Code: 0
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16400">12550</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3319</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>OnError</Data>
    <Data>NT AUTHORITY\NETWORK SERVICE</Data>
    <Data>173_203_158_226_WIN-APWS2K38OMK_Transfer Objects Task</Data>
    <Data>{B9BA203A-1400-467F-9A26-E9104B66198B}</Data>
    <Data>{21859E1F-5F28-4A04-9E5A-5D94A629A13C}</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>30/07/2010 2:14:27 PM</Data>
    <Data>0</Data>
    <Data>ERROR : errorCode=-1073548784 description=Executing the query "CREATE USER [oneworldunited] FOR LOGIN [oneworldun..." failed with the following error: "'oneworldunited' is not a valid login or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
 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()</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        SQLISPackage100
Date:          30/07/2010 2:14:27 PM
Event ID:      12291
Task Category: None
Level:         Error
Keywords:      Classic
User:          NETWORK SERVICE
Computer:      WIN-APWS2K38OMK
Description:
Package "ShellPackage" failed.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLISPackage100" />
    <EventID Qualifiers="16385">12291</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3318</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security UserID="S-1-5-20" />
  </System>
  <EventData>
    <Data>ShellPackage</Data>
  </EventData>
</Event>

Log Name:      Application
Source:        MSSQLSERVER
Date:          30/07/2010 2:14:27 PM
Event ID:      5084
Task Category: Server
Level:         Information
Keywords:      Classic
User:          N/A
Computer:      WIN-APWS2K38OMK
Description:
Setting database option DB_CHAINING to OFF for database oneworldunited_new.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQLSERVER" />
    <EventID Qualifiers="16384">5084</EventID>
    <Level>4</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2010-07-30T19:14:27.000Z" />
    <EventRecordID>3317</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WIN-APWS2K38OMK</Computer>
    <Security />
  </System>
  <EventData>
    <Data>DB_CHAINING</Data>
    <Data>OFF</Data>
    <Data>oneworldunited_new</Data>
    <Binary>DC1300000A00000010000000570049004E002D00410050005700530032004B00330038004F004D004B000000070000006D00610073007400650072000000</Binary>
  </EventData>
</Event>
Open in new window
ASKER CERTIFIED SOLUTION
Raja Jegan R
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
omegalove
ASKER
let me check this out on Tuesday.
:-)
omegalove
ASKER
no complaints yet.

I think all is clear