Network Connectivity Issue

See more:

SQL-Server-2005

C#

SQL-Server

Hi,

I am calling a SSIS package using a batch script as below

@ECHO OFF

ECHO Switch to the correct path
E:
CD E:\Resource\App\914_load_pmrprint
CALL :ERROR_HANDLING %ERRORLEVEL%

ECHO Executing S914-load_pmrprint SSIS Package
DTEXEC /FILE S914-load_pmrprint.dtsx /MAXCONCURRENT " -1 " /CHECKPOINTING OFF  /REPORTING EWCDI
CALL :ERROR_HANDLING %ERRORLEVEL%
EXIT 0
:ERROR_HANDLING
SET ERROR_CODE=%1
IF %ERROR_CODE% NEQ 0 (
 ECHO.
 EXIT 40
) ELSE (
 ECHO Previous command completed successfully.
 ECHO.
)
GOTO :EOF

The SSIS package has a connection to AUTH database.This exe runs every day once according to the scedule.

when the job run for the first time it fails with below network conectivity error message. Then i restart the exe and it complete successfully. could anyone please let me know why is this happening

Error: 2012-04-14 22:00:24.08
   Code: 0xC0202009
   Source: S914-load_pmrprint Connection manager "Auth"
   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 Native Client"  Hresult: 0x80004005  Description: "Login timeout expired".
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Named Pipes Provider: Could not open a connection to SQL Server [53]. ".
End Error
Error: 2012-04-14 22:00:24.32
   Code: 0xC00291EC
   Source: SQL_LOADWorkAdtPmrPrint Execute SQL Task
   Description: Failed to acquire connection "Auth". Connection may not be configured correctly or you may not have the right permissions on this connection.
End Error