Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-03 : 07:48:52
|
| Kevin writes "We run a DTS package every night as a part of our nightly processes which updates all order, shipping, back order, and sold out tables on our data warehouse. The DTS package consists of approximately 25-30 steps and is quite involved. Now on to the problem...every night for the past 3 weeks or so the DTS package has been erroring out with the following error message: "[DBNETLIB][ConnectionRead (recv()).]General network error.". I apologize, I realize this error message is very vague, but it is all I have to go on. I have researched Microsoft's knowledge base and site with no success....I have found a few hits when searching based on the error message, but nothing related to our problem. I know that this is not allot to go on, but I really am at a loss and would appreciate any assistance or advice you could provide me. Please understand that our SQL DBA recently left the company and I sort of inherited the data warehouse because I was the only one on staff remotely equipped to handle the situation....I am an AS/400 programmer and have some experience with SQL and SQL server, but my experience is limited. One other thing that I wanted to mention was that the fellow who designed this DTS has a connection established prior to each step in the DTS. For instance, CONNECTION TO DB1 -> Perform pump task -> CONNECTION TO DB2 -> Perform pump task -> CONNECTION TO DB1 -> Perform SQL Task... Notice how in my example a connection to database 1 was initiated once before the first pump task then again before the last step, SQL Task. Is this necessary. Couldn't I have just opened a connection at the onset of the DTS and closed it after the DTS has completed.....thereby, reusing the connection throughout the DTS as necessary rather than opening new connections. Again any assistance that you can provide would be greatly appreciated.Thanks in advance,Kevin" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-03 : 15:52:58
|
| The database server is unable to connect to another server, that is what the error means. Is it trying to connect to other SQL Servers? If so, is the MSSQLSERVER service started on the other servers? Can you register these other servers on your database server?You do not need to use multiple connections to the same database server if they are using the same account.Tara |
 |
|
|
|
|
|
|
|
DTS general network error