Re: Master sys.xp_delete_file not found?

Yes I realized that exact same thing but my question is how and where do you
edit the SSIS package. I found no where to actually make that change....

"Kalen Delaney" wrote:

How about trying it with the correct schema, which you have in your subject
line:

EXEC master.sys.xp_delete_file

--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com


"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