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 |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2007-11-30 : 14:34:00
|
| At about 2AM everyday we do the follow for loading the data into sql database using sql job which has DTS packages.1. Drop tables2. Create tables3. Load data using DTS from SOA files to sql tables 4. Create indexes on all the tablesThe create index step failed and here is the err from teh job history: BY seeing the error it looks like the netwrok connection was lost during the job run, but I am not sure, any ideas..Thanks.The last step to run was (Create Index):Executed as user: username. ...Start: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 11 (B) Error string: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSSendMailTask_1 DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transfo... Process Exit Code 2. The step failed. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 01:41:50
|
| Looks like so. Try connect with ip address instead of host name, or with named pipes. |
 |
|
|
|
|
|
Create Index error