File system task error ; Access to the path " " is denied
-
23 noiembrie 2011 20:37
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?
Thanks
shamen
Toate mesajele
-
23 noiembrie 2011 20:52
It says Access to the path " " is denied, it means that the variable that you're trying to use is blank or not assigned properly.
Randy Aldrich Paulo
MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog
BizTalk Message Archiving - SQL and File- Editat de Randy Aldrich Paulo 23 noiembrie 2011 20:53
- Marcat ca răspuns de shamen 25 noiembrie 2011 16:43
-
24 noiembrie 2011 06:57
Hi,
you can do requirement by using the file system task in SSIS which you tried. Just look into the below thread which discusses for moving files to respective folders.
Thanks Karthikeyan Anbarasan http://f5debug.net/ -
24 noiembrie 2011 06:57
Also to get some clear step by step process on manipulations will folders and files using the file system task check the below link.
Thanks Karthikeyan Anbarasan http://f5debug.net/ -
24 noiembrie 2011 06:58
Check this article on manipulating the XML document with the script component as source. Hope this will be useful as well
Thanks Karthikeyan Anbarasan http://f5debug.net/ -
25 noiembrie 2011 16:44
Thanks all..I was not assinged the variable properly. I have given the fully qualified name without the file type.
but once i change it as shown below, it works.
\\mypath\foldername\filename.xml
Thanks
shamen -
12 martie 2012 11:25
In my case SQL Agent running in Network Service Account and I gave full access to the folders for the NetworkService account.It worked fine.
Thanks
Manoj