Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Business Intelligence - Integration Services - FTP Task - Can't save password Expand / Collapse
Author
Message
Posted Tuesday, April 09, 2013 10:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 10:15 AM
Points: 6, Visits: 22
How do you make an FTP connection save the password?
Post #1440455
Posted Wednesday, April 10, 2013 6:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 10:15 AM
Points: 6, Visits: 22
I just discovered that the password is saved automatically. It just looks as if it's blank when you examine the connection again.

Sorry for the noise.

Tom
Post #1440762
Posted Monday, April 15, 2013 11:46 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 18, 2013 12:37 AM
Points: 33, Visits: 68
Hello trapnell,

In SSIS, when you use a FTP Connection first time you have to enter a password for your ftp server, after then it get automatically configured to ssis package and you need not to provide it again.

Also if you create a configuration file for your SSIS package which contain a FTP task you have to provide the password in the config (.xml file) once, by default while generating the configuration file SSIS make it bank.

Now if you want to get rid of typing the password again and agian , then simply you can use the text file in which you provide your credentials and commands of FTP Server and then use Execute Process Task instead of FTP

Using this alternative you have only to mention one time and then rest the process will handle.


For more details you can contact me.

Thanks....
Post #1442590
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse