Also, my further testing shows that the first 2-3 times the package would run successfully and Execute SQL task under "OnError" event which I purposely trigger would run okay. After...

John, you are absolutely correct! My DB connection is used in like 3 different tasks. Wow, I didn't realize that everytime it's called, it would use up a connection. And...

Sorry,I am not very good at SS yet.

I found the "SQL Server Logs" under Management. Is that the "Event Log" you meant?

I did see the error message states" "Could...

Hi John,

Profile is such a good idea. I should have thought about it. I've finally figured out the problem was because of the data type issue and the error shows...

I use SS2008 developer's version. Thanks again for all your time and suggestions.

It shouldn't be the concurrent issue then. I checked that I should have 10 concurrent connections. Also on...

Actually this should not be related to the concurrent problem. Because I restarted the SQL server, and even reboot the machine and it still got the same "The statement has...

How did concurrent processes happen? Does it mean the previous process didn't work? How do I clean it up then?

Thanks a lot!

John, thanks a lot for your suggestions.

How do I find out the number of concurrent processes and how can kill the older processes?

Thanks again!