My trasformation end casually (and not alway) with this error: [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'PC-PC'. what means? regards nico

Just check the file(Access) permissions(Read/Write)...

Just check the file(Access) permissions(Read/Write)... I would disagree with Kumar9, MS Access is a file based database and the error you are getting is from the fact your package is trying to say update a data segment that is being locked up by an external user. Further to the above, you need to review your solution design and try to refrain from operating on shared sources. Arthur My Blog

If you could provide what is that you are trying to achieve in the package, it would help. And when the package is executed, where exactly does it stop and is it consistent at that point of failure? Looks like you are trying to write into Access file? Happy to help! Thanks. Regards and good Wishes, Deepak.

Just check the file(Access) permissions(Read/Write)... I would disagree with Kumar9, MS Access is a file based database and the error you are getting is from the fact your package is trying to say update a data segment that is being locked up by an external user. Arthur My Blog

Which driver you are using for connection?? Jet OLEDB OR Access ODBC driver Let us TRY this | My Blog :: http://quest4gen.blogspot.com/