This post shows you one of the possibilities to resolve the error “OLE DB provider “SQLNCLI11” for linked server “server” returned message “Query timeout expired”. This error actually from SSIS Data Flow but do not look into SSIS. We resolve it by setting this is in our SQL Server.
exec sp_configure ‘remote query timeout (s)’ , 0;
reconfigure with override;
Thanks to our friend Hamid for helping.