File system task error ; Access to the path " " is denied


  • HI All,

    I have created a simple package to copy xml files  from multiple source folders  to destination folder.

    Folder names and paths are stored in a sql table.  I use execute sql taks to get folder and path names. set the restult set to full result set in the execute sql task.

    Then for each loop is used to loop through each file name. File system taks is inside the for each loop. Destination vairable and source varable were created and assigned them inthe file system task.

    But I am getting an error message.

    [File System Task] Error: An error occurred with the following error message: "Access to the path '\\cor\Groups\DN\Share2\Servicing \RESPONSE_FILES\Services' is denied.".

    But I am able to do this if i design the package to move just one file. i.e without using variables. I get the error message only when I use variables.

    Can anyone tell me how to fix this please?



    23 noiembrie 2011 20:37


Toate mesajele