Before you call sp_ExecuteSQL, you need to populate @ParmDefinition with, somewhat unsurprisingly, given its name, the definitions of all the parameters.

You do not appear to have populated @ParmDefinition.

This appears to be a blog post. Please add some descriptive text, if you think that this will assist others.

I compared execution plans ... my version seems significantly less expensive, at least on this tiny amount of data.

jasona.work (11/17/2016)

---

Phil Parkin (11/17/2016)

---

jasona.work (11/17/2016)

---

Hugo Kornelis (11/17/2016)

---

EDIT: To clarify, *some* features that were enterprise only were in my opinion also easy to explain and understand. But not all. Stuff like...

Does this get you any closer?

WITH ApplicationReplyNames AS

(

SELECT u.c.value('@Name', 'varchar(100)') as ApplicationReplyName,u.c.value('../../@MerchantReferenceNumber', 'varchar(100)') as MerchantReferenceNumber

from @xml_data.nodes('/Report/Requests/Request/ApplicationReplies/ApplicationReply') u(c)

)

select t.c.value('../../../../@MerchantID', 'int') as MerchantID,

t.c.value('../../@MerchantReferenceNumber', 'varchar(100)') as MerchantReferenceNumber,

t.c.value('(@Number)[1]', 'int') as LineNumber,

t.c.value('(UnitPrice)[1]', 'decimal(18,2)') as...

jasona.work (11/17/2016)

---

Hugo Kornelis (11/17/2016)

---

EDIT: To clarify, *some* features that were enterprise only were in my opinion also easy to explain and understand. But not all. Stuff like compression and TDE...

That screen shot shows that the service is running. Can you explain why you think that it is a problem?

kathy.plamann 36011 (11/17/2016)

---

Hi

I've install SQL Server Reporting Services 2014 and I have the following image that appears under SQL Server Services. I installed Reporting services to install and configure. I...

Jerid421 (11/17/2016)

---

Uh... wow, that was easy. It ran without error. I'm a relative newbie. Can you tell me why there was an error. Was it because...

Try changing this to None.

BWFC (11/17/2016)

---

Thanks Phil. It's really frustrating that it doesn't continue to log.

There is an OnError event handler in place and it's that that stops the job. It...

spin (11/17/2016)

---

aaarrggghhhh

ok, so i have managed to get it to run.

The package is deployed to SSISDB.

If i manually run the package it fails.

I discovered an option in Advanced tab...

Gaja (11/17/2016)

---

Hi All,

I am inserting data from customer table to fact_customer

customer table has duplicate records with Customer ids but some of columns having different data i want to combine this...

BWFC (11/17/2016)

---

I have an SSIS package to load our data warehouse overnight. This package calls a series of child packages that for the most part are based on Execute...