June 24, 2009 at 12:29 pm
I am trying to copy a file from one server to another server using file System Task.
The file is on server , let's say A and the real full file path name is \\sbcrs03\AS400Data\update\QIZ.txt which is in a variable called FullDataServerPathFileNm.
Another variable holds the Destination path- \\sbcrsposdevqa\C$\Posimport\
which is also in a vraible called FullSqlServerPathFileNm.
This is the error I get--
File System Task] Error: An error occurred with the following error message: "Access to the path '\\sbcrsposdevqa\C$\Posimport' is denied.".
Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Am I am doing smething wrong here.
I am running my ssis in my local machine.
Also I try to map the destination path into my local drive, still i got the error.
June 24, 2009 at 1:23 pm
It sounds like you installed SQL Server using an account that does not have network permissions. You need to change the logon account for the services to one that does. Since you're mentioning UNC paths, you might need to use a domain account for this. Also, make sure that this service account has the necessary permissions for that directory.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply