And how do i do that????

Help pls.............................. 🙁

Isn't it frustating??

Image Attached...

Image Attached

For the first ExecuteSQl task, the result set property is set to "Full Result Set".

For the second ExecuteSQl task, the result set property is set to "NOne".

Ok, I can see some error now in progress tab -

[Execute SQL Task] Error: Executing the query "insert into Emp_Copy(id,EmpNo,EmpName) values (?,?,?)" failed with the following error: "An error occurred...

Abhijeet,

How do i handle Null values in Execute SQL task?

The task did not fail , but it transferred only those records for which no column contains Null values.

Sure thing..

Got the answer..

I was executing my data flow task by right clicking..

When I run the entire package, event handler works..

Thanks everyone for help.

I mean there arent any validation errors in my package.

There are no errors in the data flow.

DisableEventHandlers property of DFT is set to false.

How do i find errors related to event handler? Rather I think, this is where I...

Hi,

Could not get the having clause ...

can anyonce please explain?

Will again give a try by setting failparent properties...

Thanks Rich & Anil

Hi,

I am Finally solved....

1. Set the Transaction type to supported to sequence container and all the DFTs inside. Set isolation level to Read Commited to sequence container and Read...

Anil,

Thanks. But it didnot work. What should be the transaction type for the inner DFTs?

Also, can we implement transaction when DFTs are in parallel or those needs to be executing...