Phil Parkin (9/27/2012)

---

Is the ResultSet property of the ExecuteSQL task set to SingleRow?

Have you mapped 'TableExists' to your package variable on the Result Set property page?

Phil Parkin (9/27/2012)

---

Is the ResultSet property of the ExecuteSQL task set to SingleRow?

Have you mapped 'TableExists' to your package variable on the Result Set property page?

KarenM (7/10/2012)

---

I too thought there might be a change in 2012 and that is was a trick question. 🙂

I'm glad it wasn't.

Thanks.

seth delconte (6/4/2012)

---

set @p1.modify('replace value of (/Data/Datas/Item[@primaryKeyId = ("12")]/ExtraDetails/Column/@salary)[1] with 1200')

set @p1.modify('replace value of (/Data/Datas/Item[@primaryKeyId = ("14")]/ExtraDetails/Column/@salary)[1] with 1200')