Data Not getting inserted.
Hi,
In my package the Data is not getting inserted into the OLEDB destination.
It has only 32 Rows and has stuck in Yellow State for a Long time.
What is the Issue..I checked the Mappings and Metadata they are fine..
This buffer is coming from a No Match output for a Lookup.
ERRORCODE :0xC020901E -1071607778 DTS_E_TXLOOKUP_ROWLOOKUPERROR
Kindly Help.Rakesh M J
Dont forget to mark it as Answered if found useful
MCTS,MCITP,MCSS
http://mycubeandreports.blogspot.com/
June 24th, 2011 1:00am
do you run any other data flow parallel with this one? maybe the destination table here , used in another place as source?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
June 24th, 2011 1:12am
and did you set the No match output in the general tab of lookup transform?
I mean set the not match rows to redirect to no match output in the selection combo boxhttp://www.rad.pasfu.com
June 24th, 2011 1:14am
Hi Reza,
There is a Parallel Component which is an Update to the same table which is an OLEDB Command which is having a table lock .
I see no option to remove table lock in SQL OLEDB Command.
How to resolve this issue.
Rakesh M J
Dont forget to mark it as Answered if found useful
MCTS,MCITP,MCSS
http://mycubeandreports.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
June 24th, 2011 1:27am
you mean the MATCH output connected to an OLEDB Command? if yes, this doesn't mean parallel as I meant . because on every row only one of components will execute : oledb command or oledb destination.
Did you checked the No match output in the general tab of lookup component editor:
set the "specify how to handle rows with no matching entries" to the "redirect rows to no match output"http://www.rad.pasfu.com
June 24th, 2011 2:05am