12-31-2013 02:09 AM
Iam getting this error in extract transform of DI studio.
Error: Sort execution failure.
Although I have not used any order by clause in extract. Please suggest the reason for this error.
12-31-2013 06:10 AM
Depending on what you're doing, an Extract transform (SQL) may perform a sort without an order by clause being specified.
If so, this error is "typically caused by a lack of disk space or memory or a less-than-optimal system option setting". See 39705 - Troubleshooting Sort Initialization and Sort Execution Failure errors in SQL procedures in W...
When I get an unhelpful message like this, I always start with searching the SAS support site.
Hope this helps a bit.