I load data from source which contains 60 lakhs of records.when i run that job getting error message as"ACCONTS_FACT:[DataDirect][ODBC SQL Server Driver][libssclient21]Timeout Expired".pls help me out.
Have any rows gone down the ODBC link in that time? If not, it is an inactivity timer and perhaps you could make your job write to a file and then write a second job to load that file to the table.
ArndW wrote:Have any rows gone down the ODBC link in that time? If not, it is an inactivity timer and perhaps you could make your job write to a file and then write a second job to load that file to the table. ...
yes, my source is DRS stage which contains 60 lacks of records...
How many rows get processed in DataStage before you get a timeout? I still think that you are doing a big SELECT that doesn't return anything and thus times out. The number of rows in the table isn't the factor here, but the time it takes to deliver might be.