Re: Master sys.xp_delete_file not found?

There were a lot of complaints about not being able to delete from subdirs
but I haven't seen this one before. I suspect the error is misleading. Are
you running service Pack 1? If not I would try that first. Also are you
using a non-US dateformat? If so I heard of some problems with some
datetime formats that it had a problem with. And areyou using the .BAK
extension?

--
Andrew J. Kelly SQL MVP


"CarlT" <CarlT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E35E8346-36EC-4610-B685-FF3D5703569B@xxxxxxxxxxxxxxxx
Hi,
This is the error that I am receiving:
"Could not find stored procedure 'master.dbo.xp_delete_file"

I checked to make sure that this extended procedure did exsist in the
Master
database and it is there.
I then made sure that the permissions for this stored procedure were
granted
with and administrator user executing the ssis package.

Sorry if I was not specific in the first post but i have posted this
before
and the only responses were from people who had the same problem.

Thank you for responding.


"Andrew J. Kelly" wrote:

Telling us that they just don't work is not much to go on. They do in
fact
work and thousands of people are using it without any issues. So if you
want
some real answers you need to provide more details than that. Are you
getting errors? If so what do they say?

--
Andrew J. Kelly SQL MVP


"CarlT" <CarlT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F84B3E79-EE39-41DE-9504-D1FF4100C73B@xxxxxxxxxxxxxxxx
Please I need help in removing older database backups using SSIS.
I do not want to remove these backups manually every day.
I have tried to use the tools supplied with SQL 2005 and as far as I
can
tell they just don't work.
Does anyone or Microsoft have any answers for that.
Please any help in this would be appreciated.





.

Relevant Pages