INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SSIS Pckg FTP Task FTP Connection Manager will not store or save password

SSIS Pckg FTP Task FTP Connection Manager will not store or save password

(OP)
Using Visual Studio 2008 with MSSQL Server 2008 Sp2 on Windows Server 2008 R2

Building a pckg to FTP files to remote server, however, it fails because the connection manager will not save the password.
I cab successfully test, but once connection manager closed, pckg saved and closed, the FTP user password is not stored so
connection keeps failing.

Any assistance in resolving is appreciated.

Thanks,
Andrew

RE: SSIS Pckg FTP Task FTP Connection Manager will not store or save password

Put password in variable and use expressions to configure connection with password from variable

RE: SSIS Pckg FTP Task FTP Connection Manager will not store or save password

(OP)
Thanks for reply. Not to sure where to apply the expression. I have the FTP Task withih a For each loop container.
I tried to add a script task and put the password in a variable there, but nor sure I did it correctly, it didn't work.
I placed the script task within the container as well. Not sure how to relate FTP task and Script task.

I am non-technical and new to SSIS, could benefit from more details if you;re willing to provide.

Thanks for sharing your input.

Andrew

RE: SSIS Pckg FTP Task FTP Connection Manager will not store or save password

(OP)
gk53,

Got it working. Had to execute script task prior to FTP Task and had misspaelled connection name.

Thanks for helping.

Andrew

RE: SSIS Pckg FTP Task FTP Connection Manager will not store or save password

Hi Andrew, could you show where you put the code?
Thanks,
Michael

RE: SSIS Pckg FTP Task FTP Connection Manager will not store or save password

(OP)
Michael,

Env = (VStudio 2008) (MSSQL 2008 R2).
In the for loop container I have a script task, then ftp task then a sendmail task (optional).
An FTPconnectionmanager and a sendmailconenctionmanager

In the script task I have the following code;
--

using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;

namespace ST_0e9e309f48b74816bfd49ead85ff2639.csproj
{
[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
{

#region VSTA generated code
enum ScriptResults
{
Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
};
#endregion

Hope this helps,
Andrew

public void Main()
{
ConnectionManager FTPConn;
FTPConn = Dts.Connections["FTP Connection Manager"];
FTPConn.Properties["ServerPassword"].SetValue(FTPConn, Dts.Variables["FTPPassword"].Value);

Dts.TaskResult = (int)ScriptResults.Success;
}
}
}

RE: SSIS Pckg FTP Task FTP Connection Manager will not store or save password

Thanks for the reply, it helps.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close