Error msg and lack of password save on FTP task in SSIS -
03-12-2008
, 08:49 AM
I am relatively new to SSIS and am trying to set up an FTP task. I
have run into a twofold problem:
1. The password will not save in the FTP Connection Manager. I see the
password saving in the serverpassword area of the FTP Connection
Manager properties window but not in the FTP Connection Manager
Window.
2. When I run the FTP Task I receive the following error msg:
[FTP Task] Error: An error occurred with the following error message:
"Object reference not set to an instance of an object.".
The File Transfer area of the FTP Task is set up as follows:
IsRemotePathVariable: False
RemotePath: //rcg
IsLocalPathVariable: False
LocalPath: Reports
OverwriteFileAtDest: False
Operation: ReceiveFiles
IsTransferAscii: False
There are no expressions set up for this FTP Task. I am simply trying
to run the FTP Task inside of the solution(i.e. executing the FTP
Task) to test to see if the task is working.
Hopefully someone can point me in the right direction. Any help is
appreciated.
Dave |