FTP with Configuration Manager for Connection String

Question

FTP with Configuration Manager for Connection String

Dave R (UK)

SSChasing Mays

Points: 656
More actions
February 3, 2016 at 9:52 am

#304257

Hi all,
a, hopefully, quick question if I may.
I am creating packages for a client that utilises an FTP Connection Manager. I have set this up, tested and all works fine. I have saved the following properties in a configuration table
[ConnectionString] = Server01:21
[ServerUserName] = userName
[ServerPassword] = password
and again, all works fine
All would appear great however, my client wants only a single entry in the configuration table for the connection.... I have tried the following format (and a couple of variations as well)
[ConnectionString] = Server01:21.userName.password
in the configuration table and the job now fails stating
[FTP Script Task] Error: Error: An error occurred in the requested FTP operation. Detailed error description. The password was not allowed
So the questions? Is it possible to set the ConnectionString in this manner? Have only found examples where a string is set like this and then parsed out before being mapped to the connection manager properties...
Dave

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247183 More actions · Answer 1

Dave R (UK) (2/3/2016)
Hi all,
a, hopefully, quick question if I may.
I am creating packages for a client that utilises an FTP Connection Manager. I have set this up, tested and all works fine. I have saved the following properties in a configuration table
[ConnectionString] = Server01:21
[ServerUserName] = userName
[ServerPassword] = password
and again, all works fine
All would appear great however, my client wants only a single entry in the configuration table for the connection.... I have tried the following format (and a couple of variations as well)
[ConnectionString] = Server01:21.userName.password
in the configuration table and the job now fails stating
[FTP Script Task] Error: Error: An error occurred in the requested FTP operation. Detailed error description. The password was not allowed
So the questions? Is it possible to set the ConnectionString in this manner? Have only found examples where a string is set like this and then parsed out before being mapped to the connection manager properties...
Dave

Not sure. Have you tried using a parameter for the conn string and making that parameter 'sensitive'?

Dave R (UK) SSChasing Mays Points: 656 More actions · Answer 2

Currently not running 2012 so not an option 🙁

Really frustrated as the solution works with the one exception of multiple lines in configuration table

Phil Parkin SSC Guru Points: 247183 More actions · Answer 3

Dave R (UK) (2/3/2016)
Currently not running 2012 so not an option 🙁
Really frustrated as the solution works with the one exception of multiple lines in configuration table

OK. Then you are back at plan B: use a single line in the config table and then use variables with expressions to parse out the bits you need.

Dave R (UK) SSChasing Mays Points: 656 More actions · Answer 4

Thanks for the confirmation Phil - will see if I can talk the client around to letting me have three entries for this connection manager :w00t:

Dave

MMartin1 One Orange Chip Points: 27862 More actions · Answer 5

Out of curiosity what Security protection level configuration are you using when you save the package?

----------------------------------------------------