Executed as user: FLEXIRENT\syssqlint02.
Microsoft (R) SQL Server Execute Package Utility Version 10.0.6000.29 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 2:43:25 p.m.
Error: 2016-09-29 14:43:25.69
Code: 0xC002F210
Source: Insert FCM Notes Execute SQL Task
Description: Executing the query " insert into FCM15.dbo.Notes (SPNoteCategoryId, Us..." failed with the following error: "Could not find server 'prodakl006p' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 2:43:25 p.m.
Finished: 2:43:25 p.m.
Elapsed: 0.686 seconds.
The package execution failed. The step failed.
assasafras
commented
8 years ago
Details
Date: 29/09/2016 2:43:25 p.m. Log: Job History (Collections - Daily (7am)) Step ID: 8 Server: INTGAKL006V Job Name: Collections - Daily (7am) Step Name: Generate Collections PPSRUploadFiles TRL
Message
Executed as user: FLEXIRENT\syssqlint02. Microsoft (R) SQL Server Execute Package Utility Version 10.0.6000.29 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 2:43:25 p.m.
Error: 2016-09-29 14:43:25.69
Code: 0xC002F210
Source: Insert FCM Notes Execute SQL Task
Description: Executing the query " insert into FCM15.dbo.Notes (SPNoteCategoryId, Us..." failed with the following error: "Could not find server 'prodakl006p' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 2:43:25 p.m. Finished: 2:43:25 p.m.
Elapsed: 0.686 seconds.
The package execution failed. The step failed.