Truy v?n m tr? v? khng c d? li?u t? my ch? SQL c th? gy ra SSIS gi th?t b?i khi b?n s? d?ng cc nh cung c?p DB2 t? 2010 c?a ng v OpenRowset v?i FastLoad ?c thi?t l?p

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2587530 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny

TRI?U CH?NG

Hay xem xet cac tinh hung sau:
  • B?n c m?t mi tr?ng Microsoft Host Integration Server 2010 ang ch?y Microsoft SQL Server 2008 h?i nh?p d?ch v? (SSIS).
  • B?n t?o m?t truy v?n ?i v?i ngu?n my ch? SQL.
  • Trong ?i t?ng i?m ?n, b?n ? ch?n ? s? d?ngOpenRowset v?i Fastload.
Trong tr?ng h?p ny, truy v?n ?i v?i ngu?n my ch? SQL tr? v? khng c d? li?u. Ngoi ra m?t l?i ?c t?o ra trn ?i t?ng i?m ?n i?m ?n my ch? lu tr? DB2. L?i gy ra cc gi th?t b?i. Ban nhn c thng bao li sau y:
L?i: SSIS Error Code DTS_E_OLEDBERROR. OLE DB c l?i. M? l?i: 0x80004005.

B?n ghi OLE DB c s?n. Ngu?n: "Microsoft DB2 OLE DB Provider" Hresult: 0x80004005 m t?: "Unspecified error".

B?n ghi OLE DB c s?n. Ngu?n: "Microsoft DB2 OLE DB nh cung c?p" Hresult: 0x80040E14 m t?: "".

GI?I PHP

Thng tin hotfix

Hotfix c h tr ang c Microsoft cung cp. Tuy nhin, hotfix ny l nh?m kh?c ph?c ch? s? c? ?c m t? trong bi vi?t ny. Hotfix ny ch? p d?ng cho h? th?ng ang g?p v?n ? ?c m t? trong bi vi?t ny. Hotfix ny c th? nh?n ?c th? nghi?m b? sung. V? v?y, n?u b?n khng b? ?nh h?ng b?i v?n ? ny, chng ti ? ngh? b?n ?i cho C?p Nh?t ti?p theo c?a ph?n m?m c ch?a hotfix ny.

Nu hotfix nay sn co tai xung, co phn "Tai xung hotfix sn co" u bai vit trong C s Kin thc nay. N?u ph?n ny khng t?n t?i, h?y lin h? v?i d?ch v? khch hng c?a Microsoft v h? tr? ? c ?c cc hotfix.

Chu y N?u v?n ? khc x?y ra ho?c n?u b?t c? x? l? s? c? l c?n thi?t, b?n c th? ph?i t?o m?t yu c?u d?ch v? ring bi?t. Cc chi ph h? tr? thng th?ng s? p d?ng ? h? tr? thm cu h?i v v?n ? ny khng ? i?u ki?n cho hotfix ny c? th?. bit danh sach y u v cac s in thoai cua Phong H tr va Dich vu Khach hang cua Microsoft hoc tao yu cu dich vu ring, hay truy cp web site sau cua Microsoft:
http://support.microsoft.com/contactus/?ws=support
Chu y Cc h?nh th?c "Hotfix download available" hi?n th? cc ngn ng? m cc hotfix c s?n. Nu ban khng thy ngn ng cua minh thi o la do hotfix nay hin khng co ngn ng o.

iu kin tin quyt

B?n ph?i c my ch? lu tr? Integration Server 2010 ?c ci ?t ? p d?ng hotfix ny.

Kh?i ?ng l?i thng tin

Ban khng phai khi ng lai may tinh sau khi ap dung ban va nong nay.

Thay th? thng tin

Phin b?n ti?ng Anh (Hoa K?) c?a hotfix ny s? d?ng m?t gi ph?n m?m Microsoft Windows Installer ? ci ?t cc hotfix. Nh?ng ngy thng v th?i gian cho nh?ng t?p tin ?c li?t k trong gi? ph?i h?p qu?c t? (UTC) trong b?ng sau. Khi b?n xem chi tiet tap tin, ngy ?c chuy?n ?i thnh gi? c?c b?. ? bi?t s? khc nhau gi?a UTC v local time, s? d?ng cc Mi gi? th? tab trong cc Ngay gi m?c trong b?ng i?u khi?n.
Cho Microsoft Host Integration Server 2010 32-bit edition
Thu g?n b?ng nyBung r?ng b?ng ny
Tn tpPhin ban tpKich thc tpNgayGiN?n t?ng
db2oledb.dll8.5.4371.2632,65624-Thng tm-201111: 36x86
ipresync.dll8.5.4371.2530,26424-Thng tm-201111: 36x86
msdrda.dll8.5.4371.2989,00824-Thng tm-201111: 36x86
?i v?i Microsoft Host Integration Server 2010 64-bit edition
Thu g?n b?ng nyBung r?ng b?ng ny
Tn tpPhin ban tpKich thc tpNgayGiN?n t?ng
db2oledb.dll8.5.4371.2632,65624-Thng tm-201111: 43x86
db2oledb.dll8.5.4371.2878,92824-Thng tm-201111: 43x64
ipresync.dll8.5.4371.2719,70424-Thng tm-201111: 43x64
msdrda.dll8.5.4371.21,716,56024-Thng tm-201111: 43x64
msdrda.dll8.5.4371.2989,00824-Thng tm-201111: 43x86

T?NH TR?NG

Microsoft ? xc nh?n r?ng y l m?t v?n ? trong cc s?n ph?m c?a Microsoft ?c li?t k trong ph?n "p d?ng cho".

Thu?c tnh

ID c?a bi: 2587530 - L?n xem xt sau cng: 04 Thang Mi 2011 - Xem xt l?i: 1.0
p d?ng
  • Microsoft Host Integration Server 2010
T? kha:
kbautohotfix kbqfe kbhotfixserver kbfix kbmt KB2587530 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:2587530

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com