October 20, 2009 at 6:21 am
Using the File System Task in SSIS 2005 to copy a directory and all the files in it. This failed on a server so I'm now working on my local PC. Trying to copy folder c:\A1 into c:\A2. There are two subdirectories in A1 and many files.
Executing via BIDS it works the first time. For all subsequent runs it errors on three of the files. All others succeed. This is the specific error for one of the files:
[highlight=#ffff11][File System Task] Error: An error occurred with the following error message: "Access to the path 'C:\A2\Profile\prod\Addins\DataLoader.xla' is denied.".[/highlight]
Trying to figure out what is different about those files. One is an XLA file (XL Add-in) and the other two are DOC (Word documents.) They are read-only but so are several others that seem to work. I don't think they are in use as I copied all the files from my server this morning to test this problem. In fact, if I copy one of the files from A1 into A1 and give it a new name the new file will also error upon the second attempt to copy it to A2. I know it's not in use because all I did was copy it in windows explorer. I have full administrative rights on my machine and obviously have control over the destination folder, A2, because some of the files are overwriteable.
Any suggestions on what file characteristics I could look for that would make these different and cause only these files to fail the copy? Thanks in advance for any help.
January 26, 2010 at 1:57 am
try it in a batch file
then you'll know whether it's SSIS or a file thing, like network permissions
does it work in BIDS on the server or did you run it on your PC? that might be something else to try...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply