I am trying to import an csv file onto a SQL 2005 table. The stored procedure works when I login with my credential. However, the stored procedure fails when I try to schedule it to run. I know it has to do with the credential of the SQLAgent services, but I still don't know how to get around it. Can someone help?