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...

Well done on sorting that out.

Presumably the package was originally developed for a 2012 back-end (using Native Client 10.1) which was migrated to 2014 (NCLI 11)?

Jerid421 (11/16/2016)

---

I was very close to completing Part 4 of the Stairway to Integration Services series and when I ran my package, I got this error:

[Execute SQL Task] Error: There...

Add a data conversion task to make your data types match.

GilaMonster (11/16/2016)

---

That only works if the log records are still in the transaction log (which means you need to be doing the investigation very soon after the delete; minutes, not...