Matt-1034261 (4/23/2014)

---

Hi

I have a table which has a couple of million records in it which relate to locations around the world.

I want to be able to do a search on...

ChrisM@Work (4/23/2014)

---

Would you do it like this Eirikur or would...

Is it this that you are looking for?

😎

SELECT *

INTO #MyTemp

FROM Sales.SalesOrderHeader;

SELECT *

FROM tempdb.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE N'#MyTemp%'

DROP TABLE #MyTemp;

If you double click the Flat File Connection Manager to open the Flat File Connection Manager Editor and choose the Preview, what do you see in that column? You may...

SQLSteve (4/22/2014)

---

As mentioned above, in the file it is showing as ""Data"" instead of "data".

The failing data has ""DATA"" around it, where as all of the lines before are...

This is a very simple but effective approach using the nodes method to shred the XML

😎

DECLARE @XML XML = N'<applicant>

<summaryData>

<dataName>Age</dataName>

<dataValue>45</dataValue>

</summaryData>

<summaryData>

<dataName>LastName</dataName>

<dataValue>Jones</dataValue>

</summaryData>

<summaryData>

<dataName>NotThis</dataName>

<dataValue>Value</dataValue>

</summaryData>

</applicant>

<applicant>

<summaryData>

<dataName>Age</dataName>

<dataValue>48</dataValue>

</summaryData>

<summaryData>

<dataName>LastName</dataName>

<dataValue>Jones</dataValue>

</summaryData>

</applicant>';

DECLARE @APPLICANT TABLE

(

guid INT IDENTITY(1,1) NOT NULL

...

These two collations are...

Check out this article, Merge multiple data sources with SQL Server Integration Services[/url] and the Stairway to Integration Services[/url] here on SSC.

😎

Use either Merge Join or Lookup transformation in the Data Flow.

😎

venkyzrocks (4/21/2014)

---

Hi ,

No master table exists. The temporary master table has been posted below. I'll probably create one. So stripping off the FY** values and create a master list and...

You should use a text editor rather...

Just remove the @ from the column aliases to get the result as a node.

As I said in the previous post, switching encoding is not supported so the output will...

Nats007 (4/22/2014)

---

Hi

Getting the following warning in SSIS - SQL 2012:

[SSIS.Pipeline] Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not...

According to the RFC4180, a double quote (text qualifier) must be escaped by a double quote, don't think this is the actual cause.

How does the 246th row compare to other...

Firstly, the character code for upper and lower cases are different, even on a case insensitive system:

;WITH NB(N) AS (SELECT N FROM (VALUES...