开发者

SQL Agent and Running SSIS Across Network Not Working

开发者 https://www.devze.com 2023-03-14 14:29 出处:网络
I have a vb script which moves files from one server to another and it works successfully when run manually but when a job is created in SQL Agent to automate the process it doesn\'t perform the task.

I have a vb script which moves files from one server to another and it works successfully when run manually but when a job is created in SQL Agent to automate the process it doesn't perform the task. SQL Agent doesn't fail it simply does not perform the move.

I granted local admin rights to the account performing the task and still nothing. I copied the files manually to the local SQL Server but I still get the same outcome when 开发者_JAVA百科attempting to run the job in SQL Agent.

I also tried using FQDN but it still doesn't perform the process. Any suggestions? Please help and thanks in advance.


if you have 32 bit try:

C:\Windows\system32\config\systemprofile\Desktop  

For the package to work. If you do not have Destop folder, create one and it should work.


Try to check: C:\Windows\SysWOW64\config\systemprofile\Desktop folder for the package to work.

0

精彩评论

暂无评论...
验证码 换一张
取 消