 FTP Connection Properties / Connection String Problem -
04-28-2006
, 09:56 AM
Chaps,
we're trying to dynamically set username and password for an SSIS FTP
Connection. However, the format of the connection string is not documented,
as far as the setting of the login-properties for FTP is concerned. I have
checked several databases and forums, but haven't come to any result so far.
It looks like a password can be set only indirectly by setting the full
ConnectionString. For example the following script
Public Sub Main()
Dim conn As ConnectionManager = Dts.Connections("testConn")
conn.ConnectionString="Data Source=MySQLServer;User
ID=sa;Password=test;Initial Catalog=TestDb;Provider=SQLNCLI.1;"
Dts.TaskResult = Dts.Results.Success
End Sub
can modify an existing SQL Server Connection including the password. Note
the password is removed immediatly from the string after setting it this
way, but it seems it is still stored internally.
In an analogous way it should be possible to modify an existing FTP
Connection. Sadly, I don't know the syntax for that type of connection.
MsgBox'ing the ConnectionString for an FTP Connection looks like
168.192.1.2:21 and does not even include the ServerUserName.
Somebody had this problem before?
Tim
 |
Linear Mode
