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.
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SSMS 2012 job execution error