January 2, 2013 at 1:35 pm
I think the account needs to be added the db_ssisoperator role in the MSDB database.
I'll post back final testing results....
January 2, 2013 at 2:28 pm
Adding the account to db_ssisoperator role seems to resolve the issue.
I am still troubleshooting some issues with overwriting an existing file..
Using dtexec will create the file but will fail if the file exists.
Running the package from BIDs will always overwrite the file.
The Overwrite property of the Data_Flow_Component is set to overwrite.
When it fails it fails with the error message: Description: The file name "\\server\Folder1\Folder2\Test.txt" specified in the connection was not valid.
I have deleted the proxy account to clean things up.
I can run cmd.exe as the SQL Server service account and successfully delete the file or successfully overwrite an existing file with the copy command.
I have also seen this behavior. I delete the file. I run the package with DTexec and it fails the first time, then succeeds on the second or third run. Strange...
I will keep troubleshooting this overwrite issue...
January 2, 2013 at 3:32 pm
Applying permissions up the folder path to Folder1 seems to have done the trick. \\server\Folder1\Folder2\Test.txt
Thanks!
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply