mcfarlandparkway (10/26/2016)

---

I have a table of ssisconfig table where I stored all the connection strings with a type column.

In the package I took execute sql task and queried with ssis...

dramaqueen (10/26/2016)

---

I am currently looking at identifying duplicate names and looking for behavior patters. A duplicate in this case is very high level and there is risk involved as you...

BWFC (10/26/2016)

---

jasona.work (10/26/2016)

---

Brandie Tarvin (10/26/2016)

---

jasona.work (10/26/2016)

---

Phil Parkin (10/26/2016)

---

HanShi (10/26/2016)

---

BLOB_EATER (10/26/2016)

---

I liked Eric's response - "get a job...

kesavan.rv (10/26/2016)

---

Hi Friends,

All off sudden in my PROD SQL server memory was reduced to zero(As the minimum memory was set to 0).

Is there any way to find which one...

Ricky Valencia (10/26/2016)

---

Our client described to us how they wanted to migrate their data from one datacentre to another datacentre as follows:

•An application will generate csv files to a folder...

+1, this is the...

HanShi (10/26/2016)

---

The problem is that they probably...

Luis Cazares (10/25/2016)

---

Phil Parkin (10/25/2016)

---

Luis Cazares (10/25/2016)

---

However, the OUTPUT clause will generate an empty result set when no rows are updated, so that should work.

And with a single statement and...

Luis Cazares (10/25/2016)

---

However, the OUTPUT clause will generate an empty result set when no rows are updated, so that should work.

And with a single statement and the error handling just...

And I missed that. Definitely need the ORDER BY.

DesNorton (10/25/2016)

---

It can also be done without the CTE or the need for a @results table.

And since it's a single statement, there is no need for the explicit transaction.

CREATE PROCEDURE...

Try getting rid of the ON PRIMARY sections ... they're probably the default option, anyway. There's probably a bracket or a comma in the wrong place.

Multi-threaded testing suggests that READ COMMITTED works just fine, using your atomic code.

Thanks again.

What's the compatibility level of the database you're working in?

@Patrick123 (10/25/2016)

---

I am new to SSIS .I want to learn the difference between .DTSX and .ISPAC.I tried to google it but it some what hard to learn,Can anyone please let...