chuck.forbes (11/22/2016)

---

I'm a bit confused about a recent security patch application. We applied the Security Patch KB3194722, but in looking at the server prior to this, the SQL Server version...

See here[/url] for an introduction to SSIS.

SQL Server Integration Services is an ETL (Extract/TransformLoad) tool which is packaged with SQL Server.

It's good for moving data from A to B, where A and B...

I stopped responding at the point where you mentioned that the linked server is an Excel spreadsheet, as I have...

zoggling (11/22/2016)

---

Phil Parkin (11/22/2016)

---

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web server running...

Thom A (11/22/2016)

---

Phil Parkin (11/22/2016)

---

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web server...

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web server running Windows Server 2008...

mcfarlandparkway (11/21/2016)

---

Yeah, TY

I have commented that return statement and kept a break point on Execute sql task. I can see all the values which I am passing to that SP...

If you are prepared to accept the occasional false positive, the checksum method is not so bad.

The Except method is, however, more robust.

Jeff Moden (11/21/2016)

---

Now you have...

EXCEPT on a 2-million-row resultset is tidier than a column-by-column comparison, but still not to be recommended, IMO.

mcfarlandparkway (11/21/2016)

---

I didn't understood this point

I understand that, but OUTPUT parameters in a proc do not need the RETURN keyword, all you need to do is set their value within...

PJ_SQL (11/21/2016)

---

Yes it would need to update multiple files in the table.

Are you implying that I import the file received from third party to a table and then update each...

mcfarlandparkway (11/21/2016)

---

I changed from Select to SET.

Still its showing error

"Input string was not in a correct format.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,...

I understand that, but OUTPUT parameters in a proc...