I have stop all sql server services, manually added sysadmin sql server role to the windows account used by the agent and restarted all sql services and it is now working.

I am not sure if that really solved the problem but it seems fine and data is correctly bulk inserted to the db! Im now going through ssrs

Thanks for your help Chad