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 |
|
ysr_aurora
Starting Member
1 Post |
 Posted - 2009-03-24 : 06:03:09
|
| I have 2 jobs running through Management Studio. One job runs at 5.30 in the morning and the other at 7.00 in the morning. Both the jobs use the same ETL packages. The only thing that differs is the variables they use.I have been getting the errors like 1.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Deferred prepare could not be completed.".An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The incoming tabular data stream (TDS) protocol stream is incorrect. The stream ended unexpectedly.".2. OLE DB error occurred while loading column metadata. Check SQLCommand and SqlCommandParam properties.3. "Lookup Table" (79) failed the pre-execute phase and returned error code 0x80004005.The job contains 4 packages running one after the other. Till recently the second job(7.00 am ) was failing with the above errors after I have upgraded with SP3 the first job is failing now and second is working fine. Any ideas in this would be of great help.Thanks,Sri |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-12 : 10:21:33
|
If TDS data stream is wrong, it indicates something went wrong on the network. The data sent was not successfully sent.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
ETL Fails Irregularly