Hi,
We need to transfer objects from source to destination database in SSIS, but my destination DB is participating in AlwaysOn and I would like to provide 'Multisubnetfailover=True' as additional parameter but I'm unable to do as it just asks for Username and password in SMO connection manager while configuring source and destination servers connections.
Please advise.