Hey guys..m trying to load the data from Raw file into a SQL server table but I am getting the following error: [OLE DB Destination [88]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "BOMSSDEVL66.SHARED" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [SSIS.Pipeline] Error: component "OLE DB Destination" (88) failed the pre-execute phase and returned error code 0xC020801C. [SSIS.Pipeline] Information: "component "OLE DB Destination" (88)" wrote 0 rows. Can anybody please throw some light on it?

While configuring the Destination data adapter you need to test the connection at the point of supplying the credentilas,ProviderName, Servername: and Authentication etc..After this just hit "TestConnection".

Let me guess: you are running the package as a SQL Agent job and you do not have it set to execute under a domain based proxy account? If yes, your package has no rights to access the filesystem. Thus, to remedy schedule this package to run under an account (proxy) that has all the needed privileges. This is how.Arthur My Blog

Thank you guys for the reply.. 1) I have tested the connection in connection manager..also during development, I can preview the dest_table and map the columns from source to destination..only during runtime, I get this error. 2) I am just trying to run the developed package from BIDS..thats all.. I hope this info is useful..let me know if you guys need anything else..

Guys pls help me with this issue.. :(

Is this possibly your issue? http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/da076e51-8149-4948-add1-6192d8966ead/Jorge Segarra SQLChicken.com || Follow me on Twitter! || SQL University Please click the Mark as Answer button if a post solves your problem!

Could you please tell us more about how you set up your DFT? As an aside, my thinking is you think it is a raw file but it perhaps is a disaster file in terms of data it represents.Arthur My Blog

Guys the problem is solved.. Thanks a lot to all for your valuable suggestions.. The resolution for me was.. I have three containers in my project..out of which 2 had TransactionOption property set to SUPPORTED and the third one had it set to REQUIRED..but as I was not starting any transaction, third container was obviously failing..so just set its property to SUPPORTED and everything starte working fine :))))))))))))