Wednesday, February 29, 2012

FIX: Access To The Path Is Denied

Error Message
Executed as user: domain\loginname. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  1:30:00 AM  Error: 2012-02-28 01:30:01.60     Code: 0xC002F304     Source: File System Task File System Task     Description: An error occurred with the following error message: "Access to the path is denied.".  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  1:30:00 AM  Finished: 1:38:05 AM  Elapsed:  485.703 seconds.  The package execution failed.  The step failed.

Background Of The Issue:
Let me give you the background of my SSIS Package and error, I had created a package in SSIS for daily backup of all db’s and move 24hrs old backup to another folder and delete older than 3 days backup files from that folder. 
The job is successfully backing up the databases but while moving it is throwing error that, the file is in use by other program (Access to the path is denied).

Just manually move those old files to desired location/folder and start running the job, it will run successfully, I am not saying that this is the solution for this, but in my case it is the solution.

If you have any solution for this apart from this please share here in comments section. I will post your answer in my blog with your name.

Access to the path is denied, Error: Access to the path ' ' is denied., SSIS - Access to the path is denied, XML Source : Access to the path is denied error, How to solve this error “Access to the path, sql server 2008 r2 Access to the Path Error in Visual Studio, Access to the path is denied error, SSRS subscription error : Windows File Share, Solving: Access to the path "…..\*.rptproj.user" is denied in SQL, Access Denied error when running SQL Server Transfer Objects, SSRS 2008 R2 Access to path is denied, SSRS 2012 Access to path is denied, SSRS 2005 Access to path is denied,


Post a Comment