Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Data Collection  [new]
Александр52
Member

Откуда: Кокосовые острова ส็็็็็
Сообщений: 5136
Коллеги, добрый день.

Не получается настроить Data Collection на одном из серверов. Прошу помочь.
1. В конфигураторе создаю новую БД - успешно
2. В пункте Set Up Data Collection - выбираю эту БД + создаю папку кэша(при этом, при нажатии на кнопку Next - зачем то запрашивает соедниение с сервером, на других серверах такое окно не появлялось). - так же успешно


При этом Сеты остановлены. Если запускаю вручную - они тут же снова останавливаются.
При этом папка кэша пустая.


Лог ошибок в джобе ниже:
+
A call to stop a collection set is only valid if the set is executing in continuous collection modeSSIS error. Component name: TSQLQuery_CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_3_Collect, Code: -1071636471, Subcomponent: Connection manager "ConfigConnection", Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in opening server connection".

.
SSIS error. Component name: SQL - Get UTC Time, Code: -1073573396, Subcomponent: Execute SQL Task, Description: Failed to acquire connection "ConfigConnection". Connection may not be configured correctly or you may not have the right permissions on this connection.

.
The master package exited with error, previous error messages should explain the cause.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
SSIS error. Component name: TSQLQuery_CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_3_Collect, Code: -1071636471, Subcomponent: Connection manager "ConfigConnection", Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in opening server connection".

.
SSIS error. Component name: SQL - Get UTC Time, Code: -1073573396, Subcomponent: Execute SQL Task, Description: Failed to acquire connection "ConfigConnection". Connection may not be configured correctly or you may not have the right permissions on this connection.

.
The master package exited with error, previous error messages should explain the cause.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
Failed to connect to the configuration server. Inner Error ------------------>
Row #: 0 Source: "Microsoft SQL Server Native Client 10.0" Description: "Unable to complete login process due to delay in opening server connection" Help File: "(null)" Help Context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
SSIS error. Component name: TSQLQuery_CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_3_Collect, Code: -1071636471, Subcomponent: Connection manager "ConfigConnection", Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.

".

.
SSIS error. Component name: SQL - Get UTC Time, Code: -1073573396, Subcomponent: Execute SQL Task, Description: Failed to acquire connection "ConfigConnection". Connection may not be configured correctly or you may not have the right permissions on this connection.

.
The master package exited with error, previous error messages should explain the cause.
SSIS error. Component name: DFT - Collect Query 0, Code: -1071636389, Subcomponent: Raw File Destination [48], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_30.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Retrieve Performance Counters, Code: -1071636389, Subcomponent: RFD - Write to cache [1721], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50.CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_4.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Retrieve Performance Counters, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "RFD - Write to cache" (1721) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 0, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (48) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 1, Code: -1071636389, Subcomponent: Raw File Destination [45], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_31.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 1, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (45) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 2, Code: -1071636389, Subcomponent: Raw File Destination [108], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_32.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 2, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (108) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 3, Code: -1071636389, Subcomponent: Raw File Destination [60], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_33.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 3, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (60) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 4, Code: -1071636389, Subcomponent: Raw File Destination [63], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_34.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 4, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (63) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 5, Code: -1071636389, Subcomponent: Raw File Destination [72], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_35.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 5, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (72) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 6, Code: -1071636389, Subcomponent: Raw File Destination [75], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_36.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 6, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (75) failed the pre-execute phase and returned error code 0xC020205B.

.
The master package exited with error, previous error messages should explain the cause.
SSIS error. Component name: DFT - Retrieve Performance Counters, Code: -1071636389, Subcomponent: RFD - Write to cache [1721], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50.CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_4.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Retrieve Performance Counters, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "RFD - Write to cache" (1721) failed the pre-execute phase and returned error code 0xC020205B.

.
The master package exited with error, previous error messages should explain the cause.
SSIS error. Component name: DFT - Retrieve Performance Counters, Code: -1071636389, Subcomponent: RFD - Write to cache [1721], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50.CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_4.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Retrieve Performance Counters, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "RFD - Write to cache" (1721) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 1, Code: -1071636389, Subcomponent: Raw File Destination [45], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_31.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 1, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (45) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 2, Code: -1071636389, Subcomponent: Raw File Destination [108], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_32.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 2, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (108) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 3, Code: -1071636389, Subcomponent: Raw File Destination [60], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_33.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 3, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (60) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 4, Code: -1071636389, Subcomponent: Raw File Destination [63], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_34.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 4, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (63) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 5, Code: -1071636389, Subcomponent: Raw File Destination [72], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_35.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 5, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (72) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 6, Code: -1071636389, Subcomponent: Raw File Destination [75], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_36.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 6, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (75) failed the pre-execute phase and returned error code 0xC020205B.

.
The master package exited with error, previous error messages should explain the cause.
SSIS error. Component name: DFT - Collect Query 1, Code: -1071636389, Subcomponent: Raw File Destination [45], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_31.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 1, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (45) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 2, Code: -1071636389, Subcomponent: Raw File Destination [108], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_32.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 2, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (108) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 3, Code: -1071636389, Subcomponent: Raw File Destination [60], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_33.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 3, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (60) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 4, Code: -1071636389, Subcomponent: Raw File Destination [63], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_34.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 4, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (63) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 5, Code: -1071636389, Subcomponent: Raw File Destination [72], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_35.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 5, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (72) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Collect Query 6, Code: -1071636389, Subcomponent: Raw File Destination [75], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_36.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Collect Query 6, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "Raw File Destination" (75) failed the pre-execute phase and returned error code 0xC020205B.

.
SSIS error. Component name: DFT - Retrieve Performance Counters, Code: -1071636389, Subcomponent: RFD - Write to cache [1721], Description: File "W:\CASH_DATA_COLLECT\CORE-S-SQL03V1_MSSQL10_50.CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_4.cache" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full.

.
SSIS error. Component name: DFT - Retrieve Performance Counters, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: component "RFD - Write to cache" (1721) failed the pre-execute phase and returned error code 0xC020205B.

.
The master package exited with error, previous error messages should explain the cause.
SSIS error. Component name: TSQLQuery_CORE-S-SQL03V1_MSSQL10_50_CORESSQL03V1_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_3_Collect, Code: -1071636471, Subcomponent: Connection manager "ConfigConnection", Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.

".

.
SSIS error. Component name: SQL - Get UTC Time, Code: -1073573396, Subcomponent: Execute SQL Task, Description: Failed to acquire connection "ConfigConnection". Connection may not be configured correctly or you may not have the right permissions on this connection.

.
The master package exited with error, previous error messages should explain the cause.



Логи ссылаются на диск W:\CASH_DATA_COLLECT которого у нас нет.
8 дек 15, 09:58    [18527750]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить