Hi Guys,

Please help me on this.

Source in my SSIS package: .csv file

Destination: OLE DB Destination

Whenever I test connection in OLEDB connection manager, connection is getting succeeds. But while executing package, giving this error. I referred solutions for this error from blogs and got the below suggestion:

Set property 'Run64bitRuntime' to false and tried the same

But still getting the error.

Where is password stored  ?

Keep check password is stored properly

Hi,

Package is using windows authentication mode.

Please suggest me how to check the where password will be stored in this case.

Thanks for ur reply.

Hi,

In connection manager properties, I can see the password stored.