How to connect databases participating in AlwaysOn through SQL Server Objects task in SSIS

  • 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.

Viewing 0 posts

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