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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics