We have two servers, backend and frontend. Frontend server has all the data and transformation logics in SSIS (METaL system) and we are executing it from backend server. We have set up linked server across SQL Servers and set Query time property to 0. When we execute this application it works fine for small set of data and completes in 4-5 minutes but starts failing if we run it for huge data set which takes somewhere around 11-12 minutes.
OLE DB provider "STREAM" for linked server "(null)" returned message "Query timeout expired".
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Please help us, it’s becoming a bit critical for us. Thanks in advance.
With Thanks and Regards
My Blog - http://arshadali.blogspot.com/