I am using openrowset in ETL for insert data to temp table. But I got some of error in SSIS (don´t have log to debug the issue) and package is failed but session/transaction and oledb is still "open". In sys.sysprocesses is status still runnable, lastwaittype is OLEDB and when I tried to kill this session nothing happend. Last possibility is propably restart the sql server.
And the question is if I can somehow prevent the server restart? Some king of timeout for openrowset or is there any other possibility how to kill the session?
Thank you Martin