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 |
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2013-04-03 : 02:50:11
|
| one day package ran successfully and next day only it fails. |
|
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2013-04-03 : 03:02:29
|
| Running from visual studio IDE? |
|
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2013-04-03 : 05:34:59
|
| sql agent job |
|
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
User::RemotePath does not exist