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 2008 Forums
 SQL Server Administration (2008)
 User::RemotePath does not exist

Author  Topic 

sravanim
Yak Posting Veteran

58 Posts

Posted - 2013-04-02 : 10:52:28
SSIS package which uses a FTP task to download some files.
what are the conditions we need to check when this type of error message occured.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-02 : 11:39:00
it means you've not created the variable RemotePath inside package but still referring it somewhere.

Declare a variable with name RemotePath in package to fix this.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sravanim
Yak Posting Veteran

58 Posts

Posted - 2013-04-03 : 02:50:11
one day package ran successfully and next day only it fails.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-03 : 02:51:48
is it running from job or from visual studio IDE?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sravanim
Yak Posting Veteran

58 Posts

Posted - 2013-04-03 : 03:02:29
Running from visual studio IDE?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-03 : 04:25:44
i mean from business intelligence development studio manually or from a sql agent automated job?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sravanim
Yak Posting Veteran

58 Posts

Posted - 2013-04-03 : 05:34:59
sql agent job
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-03 : 07:08:42
check the package and see if its correct version with required variable

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -