I have a job that was working OK until now. Now it just keeps on running and shows no rows being extracted. In director, it is stuck at this line:
DSD.BCIConnect call to SQLConnect returned informational message
A search on the key word "DSD.BCIConnect" returns lot of threads. Those posts suggest it could be a problem with the ODBC connection. I hope at least one of that posts hold good for you. BTW, You didn't explain your job design.
Well I broke the job in to parts.....from the db to a seq file and then from that file I was able to extract and perform the operations like lookups,sort etc.....was very strange....wonder what can be the reason!!....