March 4, 2008 at 7:15 am
Hi,
I have created a couple of SSIS packages to import data into my sql server 2005 database.
The first of these imports from a ms access db and the second from a fox pro db. Both of these are located on a novell server.
The packages are setup to run in consecutive steps of an SQL server job and the jobs steps are setup to run as a proxy so that they can access the databases on the novell server. The proxy uses a credential that is a network account with access to the folders on the novell server where the databases are stored.
This all seems to work ok, however the job doesnt seem to be releasing the network connections. I'm permitted four concurrent connections, so the first couple of times it runs, it is fine, but then it blows the limit and fails. I think that it is taking one connection for each of the data sources and holding on to it.
Has anyone come across this before?
cheers.
Stephen.
March 4, 2008 at 12:00 pm
Click on the source connections via the connection manager. Then look over at the properties at retain same connection. By default this is false.
March 5, 2008 at 2:54 am
oh ok, thanks for that, I'll give it a go. I guess that will force it to use the old connection will it. Any idea why its not closing them though, they just seem to build up. Or any idea how I can force it to close them?
cheers.
March 5, 2008 at 10:27 am
I have no idea why it would not close the connection after the package is done executing. Sounds like a bug to me.
March 6, 2008 at 9:35 am
thanks very much for your help. I'll keep an eye on it for a few days and see what happens with the connections.
stephen.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply