Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSMS 2012 job execution error

Author  Topic 

Blessed1978
Yak Posting Veteran

97 Posts

Posted - 2014-09-12 : 07:14:55
So I created a variable that connect to a FTP sir and retrieves dated files. When I run the package manually it runs fine however when I deploy the same package to management studio 2012. It errors out saying the path doesn't exist. Can anyone help with this

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-12 : 13:00:17
RDP to the server and try running the package there. The path/permissions/etc all have to from the perspective of the database server and not your client machine. From the RDP session, validate all paths and permissions using the SQL Server service account.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -