Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005 C#
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
 
Posted 3-May-12 21:06pm
Edited 4-May-12 0:33am
26.7K
v2
Comments
digimanus at 4-May-12 6:34am
   
which ettings for client protocols have been set in the sql server configuration manager?
SASS_Shooter at 7-May-12 15:22pm
   
in addition to the sql config for client protocols you also want to confirm what context the batch file is running under.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Nirav Prabtani 339
1 OriginalGriff 309
2 _Amy 285
3 Sergey Alexandrovich Kryukov 200
4 Kumarbs 144
0 OriginalGriff 7,889
1 Sergey Alexandrovich Kryukov 7,006
2 Maciej Los 4,014
3 Peter Leow 3,708
4 CHill60 2,762


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 4 May 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100