dbTalk Databases Forums  

Error msg and lack of password save on FTP task in SSIS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error msg and lack of password save on FTP task in SSIS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hedgracer
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.