September 1, 2015 at 12:25 am
Error Description
[LKP - If row exists in Target [104]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Deferred prepare could not be completed.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Incorrect syntax near the keyword 'as'.".
Hi Team,
Above error has occurred in DataFlow Task . This been raised only when the lookup statement generated dynamical from variable .
Your inputs are highly appreciated ...
September 1, 2015 at 2:38 am
sql crazy kid (9/1/2015)
Error Description[LKP - If row exists in Target [104]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Deferred prepare could not be completed.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Incorrect syntax near the keyword 'as'.".
Hi Team,
Above error has occurred in DataFlow Task . This been raised only when the lookup statement generated dynamical from variable .
Your inputs are highly appreciated ...
Try setting a breakpoint & examining the contents of the variable at run time, to check that it evaluates to the correct string.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 1, 2015 at 4:02 am
I have validated the variable . At run time NULL shows as just blank . This causing the issue here as this try to validate " as hbSCDType2DestCol" instead of "NULL as hbSCDType2DestCol"
Thanks for you valuable input ...:-):-):-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply