The error happens when I try to add a job to a sql server.

The whole error message :   Description: "Login failed for user 'everest_user'.".  End Error  Error: 2013-12-09 11:01:41.14     Code: 0xC020801C     Source: EvalUserSessionDetail OLE DB Destination [94]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "vmsdsqlpg01<c/>3180" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed. 

DB Version : SQL Server 2008 R2
SSIS Version : From Visual Studio 2008

Solution : 比對了SQL Server Job上的所有設定, 都跟本來可以RUN的程式沒有兩樣, 所以就參考了http://stackoverflow.com/questions/748136/acquireconnection-method-call-to-the-connection-manager-excel-connection-manage
            在Visual Studio上把Delay Validation改成True就可以了

PS. 本來的設定上, SSIS的Delay Validation是False, 但還是可以run, 一整個很奇怪，不過還好解決了

minglight 發表在 痞客邦 留言(0) 人氣()