• Hm, exactly which connections did you specify to be encrypted? You talk both about SSIS and a linked server, and that's definitely two different things. If you move data through both, you need to enable encryption in both connections.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]