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

[awaria]

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

 

[gk53]

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

 

[awaria]

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

 

[awaria]

gk53,

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

Thanks for helping.

Andrew

 

[mekohler]

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

 

[awaria]

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;
}
}
}

 

[mekohler]

Thanks for the reply, it helps.