melbert2002
MIS
- Jul 16, 2004
- 153
Hello all,
Sorry if this is a bit of a stupid question, but I am not that familiar with the best strategies of DTS scripting.
I have a DTS that I created with the DTS wizard, that on the local server, drops the local table, then recreates the table and pulls all the information from another server (same table, basicly I am copying the table)into the local table. I know that this is really not the best way to do it, but I am not having any issues on the local server.
The issue is that the SQL connections are not closing on the destination server. Every once in a while the server that I am connecting to will gain a ton of connections in a short amount of time, usually increasing 10x in volume. Could it be the DTS not closing the connections, building up and then crashing the server? I do realize that it could be, but are there issues with DTS doing this?
Thanks
Mel
Sorry if this is a bit of a stupid question, but I am not that familiar with the best strategies of DTS scripting.
I have a DTS that I created with the DTS wizard, that on the local server, drops the local table, then recreates the table and pulls all the information from another server (same table, basicly I am copying the table)into the local table. I know that this is really not the best way to do it, but I am not having any issues on the local server.
The issue is that the SQL connections are not closing on the destination server. Every once in a while the server that I am connecting to will gain a ton of connections in a short amount of time, usually increasing 10x in volume. Could it be the DTS not closing the connections, building up and then crashing the server? I do realize that it could be, but are there issues with DTS doing this?
Thanks
Mel