Hi, I have created a stored procedure which truncates a table, and then populates it from a text file using by bulk insert. It all works perfectly fine when I execute the stored procedure from within Query Analyzer, however, when I attempt to execute if as a SQL Agent Job, it fails. Profiler gives me the following error: OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error. I suspect that the problem may be caused by security implications. The Job is configured to run as the same user as when I ran it through Query Analyzer. Please can anyone enlighten me to what I may be overlooking?