May 1, 2008 at 5:27 pm
I have setup an SISS package that runs fine in Visual Studio or when I run the stored package from the MSDB. But when I schedule the package to run under SQL Server Agent, I get the following error.
Source: siSEISFTP Connection manager "siSEISFTP" Description: The file name "\\Termserv4\e drive\FTPData\SFTP\SEIS\STU_SEIS_DEMOGR.CSV" specified in the connection was not valid. End Error Error: 2008-05-01 16:19:47.92 Code: 0xC001401D Source: siSEISFTP Description: Connection "siSEISFTP" failed validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:19:47 PM Finished: 4:19:47 PM Elapsed: 0.828 seconds. The package execution failed. The step failed.
May 1, 2008 at 5:51 pm
[font="Courier New"]Can you check whether SQLAgent service account has necessary permission on the share folder??[/font]
Regards..Vidhya Sagar
SQL-Articles
May 1, 2008 at 7:37 pm
Can you give me a quick run down on how to check the permissions for the SQL Server agent?
May 1, 2008 at 7:48 pm
Thanks I figured it out.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply