In SSMS, go to Tools/Options/Query Execution/SQL Server/ANSI

and check whether the SET QUOTED_IDENTIFIER check box is set. If yes, modify your query as follows:

SET QUOTED_IDENTIFIER ON;

UPDATE People

SET ...

This appears to be something related to the DynamicsCRMSource, which most here will not know how to help you with, as it's not core SSIS.

The error occurs on extraction, I...

tnpich (6/2/2016)

---

Is it at all possible to create an Excel file (.xlsm) from data in a SQL 2014 database that would also include VBA macros, data validation and form controls?...

BLOB_EATER (6/2/2016)

---

Luis Cazares (6/2/2016)

---

After leaving the office after 8pm everyday for 2 years, I've been...

Try this

Edits: Had to use a screen shot to get the coded ampersand to render as text!

kocheese (6/1/2016)

---

I am having a hard time and hoping someone could point out what I can't seem to figure out.

We are migrating from an old environment to a...

2016 RTM is available on MSDN ...

tmmutsetse (6/1/2016)

---

Thanks Luiz its returning same information as before.

I have a sql agent job that feeds information about clients computers into a table xxxx once a week.I have a report...

yb751 (6/1/2016)

---

Hugo Kornelis (5/30/2016)

---

yb751 (5/30/2016)

---

This is great Hugo!

On a side note it might have been worth mentioning that you'll need an enterprise edition of SQL to try it...

Sean Lange (6/1/2016)

---

I have to admit that I have seen very little spam over the last several days. I am guessing that Steve and the team either got something else...

To assist others, here is the query once again, formatted for readability:

SELECT LEFT(CONVERT(NVARCHAR, a.CaptureDate, 102), 4) + '.' + SUBSTRING(CONVERT(NVARCHAR, a.CaptureDate, 102), 6, 2) AS YearDate

, ...

Are you sure? The following text appears on the CU5 page:

"This article describes cumulative update package 5 (Build...

Ok. What are you using the variables for? Are you updating them in the DF tasks, or just reading them?

komal145 (5/31/2016)

---

hi,

Is there a way that I can tell ssis to run first DFT and then second DFT . I tried put two DFT in sequence containers but since...

The ExecuteSQL task is easiest. Why do you want to change?