Thanks for your response & sorry for the confusion.

Your are correct I am using sql server to store configuration info. All the connections are using sql user & password. I have four connections , two connections to sql server 2005 (64 bit) located in our network and one is out side of our network and another email - sntp connection. Deployed the package on production SSIS server & ran successfully from DTEXECUI where as failing when I ran as sql job or ran from the query window .

xp_cmdshell 'dtexec /DTS "\File System\SOD - XXXXXXX package " /SERVER "XXXX01" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V'

failing to connect to OLDDB source which is sql server 2000 , sp3 (32 bit) where as all other connections are sql server 2005 sp2 ( 64 bit)

My question is : it running fine if i ran from DTEXECUI.

Any help is really appreciated

Error is :

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Source - SQL server2000" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

component "OLE DB Source" (570) failed validation and returned error code 0xC020801C.

One or more component failed validation.

There were errors during task validation.