Just Had the exact same issue Ugrading an old SSIS Package 2008 to SQL2016,

Changing SQL Native Client 11 OVER TO  OLEDB Provider for SQL solved it for me.