ssis - What is the expression syntax for setting a FTPConnection password with BIML? -


i generating ssis packages biml , setting ftpconnection this:

<ftpconnection name="ftp" servername="srv003809" password="" serverport="21" usepassivemode="true" >     <expressions>         <expression propertyname="servername">@[user::mst_strftp_server]</expression>         <expression propertyname="serverport">@[user::mst_strftp_port]</expression>         <expression propertyname="serverusername">@[user::mst_strftp_username]</expression>              <expression propertyname="serverpassword">@[user::mst_strftp_password]</expression>      </expressions> </ftpconnection> 

when generate package error:

could not resolve reference 'serverpassword' of type 'propertyexpression'. 'propertyname="serverpassword"' invalid. provide valid scoped name 

i have tried changing serverpassword password without success. can't find on biml forums in connection ftp connections.

how set ftp connection password using expression in biml?

i using visual studio 2010 , bidshelper 2012 (1.7.0.0)

instead of using propertyname, try using externalproperty. having similar problem using variables , expressions using odbc connection, , changing externalproperty="password" , externalproperty="username" worked me.

i still looking difference between property , externalproperty, , post once able find something.


Comments