"DQS lm s?ch khng th? giai o?n pre-execute" l?i khi b?n ch?y DQS Cleansing bi?n ?i trong SQL Server 2012

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2715968 - 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

Xem xt k?ch b?n sau y:
  • B?n s? d?ng chuy?n ?i d? li?u ch?t l?ng b?n ghi d?ch v? (DQS) Cleansing trong m?t lu l?ng d? li?u SQL Server tch h?p b?n ghi d?ch v? (SSIS) ? lm s?ch d? li?u trong Microsoft SQL Server 2012.
  • B?n thi?t l?p cc thi?t l?p "?u ra l?i c?u h?nh" c?a s? chuy?n ?i DQS Cleansing ? "Chuy?n h?ng hng." Tuy nhin, b?n khng ch? ?nh m?t v? tr ? lu ?u ra l?i.
  • B?n th?c hi?n cc gi ph?n m?m SSIS.
Trong tr?ng h?p ny, cc thng bo l?i sau y k nh?p k nh?p SSIS:
DQS Cleansing th?t b?i giai o?n pre-execute v tr? l?i m? l?i 0x80070057.

System.ArgumentException: Gi tr? khng n?m trong ph?m vi d? ki?n.
t?i Microsoft.SqlServer.Dts.pipeline.Wrapper.IDTSBufferManager100.FindColumnByLineageID (Int32 hBufferType, Int32 nLineageID)
lc Microsoft.Ssdqs.Component.DataCorrection.Logic.DataCorrectionComponent.PreExecute()
t?i Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute (IDTSManagedComponentWrapper100 wrapper)

Nguyn nhn

V?n ? ny x?y ra v? m?t ?a i?m khng ?c ?t cho ?u ra l?i ?c t?o ra cho hng khng p ?ng cc DQS tn mi?n tiu chu?n v quy t?c.

Cch gi?i quy?t khc

? gi?i quy?t v?n ? ny, s? d?ng m?t trong nh?ng phng php sau y.

Phng php 1

N?u b?n khng mu?n ? chuy?n h?ng l?i hng, h?y lm theo cc b?c sau ? gi?i quy?t v?n ?:
  1. M? cc thnh ph?n DQS trong DQS lm s?ch bi?n ?i Editor.
  2. Ch?n Th?t b?i thnh ph?n trong cc C?u h?nh ?u ra l?i danh sach tha xung ? d?i cng c?a cc DQS Cleansing bi?n ?i Editor.

Phng php 2

N?u b?n c?n ph?i chuy?n h?ng c?a b?n hng l?i th? b?n ph?i ch?c ch?n r?ng b?n c m?t v? tr i?m ?n cc l?i ? ?c chuy?n h?ng ?n.

Thu?c tnh

ID c?a bi: 2715968 - L?n xem xt sau cng: 22 Thang Tam 2012 - Xem xt l?i: 1.0
p d?ng
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
T? kha:
kbsurveynew kbexpertiseadvanced kbtshoot kbmt KB2715968 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: 2715968

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