We have a DTS package running on one of the production server. This is very critical package and not suppose to fail. Package running every night and completed most of the days and failed occasionally (1-2 a month) with the following error message. Need urgent help.
Job process - scheduler => job sent to first production server A - calls out SSI package to link with second production server B for acknowledgment and response back. Communication issue when first production server A makes SQL call to database. (Error. SQLNCLI11 " for linked server "DB_Name" returned message "Client unable to establish connection"). Error reported back to scheduler.
Server A - SQL 2014 SP3, CUR and GDR
Server B - SQL 2017, RTM, CU28
The package DTSLoad.dtsx failed.
Execution Path: C:\Containter\Package
Error: OLE DB provider "SQLNCLI11" for linked server "DB_Name" returned message "Client unable to establish connection".
Possible failure reason: Problem with the query. "ResultSet" propety not set correctly, parameter not set correctly or connection not established correctly
- This topic was modified 1 month, 1 week ago by EasyBoy. Reason: Information added
- This topic was modified 1 month, 1 week ago by EasyBoy.