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
Post a Comment