Is there a question in there somewhere?

OK, fair point. I think that you will find this information...

It's completely possible, but you'll need to write some sort of framework (or buy one) to do it. It's tough to describe in just a few sentences, as it required...

Welsh Corgi (12/20/2016)

---

I'm trying to remember how I would check for the existence of a file and Delete it in a VB.NET Script Task.

If it exist I want to Delete...

Here is the code, formatted so that others have at least a chance of parsing it. Please use IFCode tags in future.

SELECT

[Batch Number] ...

Sreejith! (12/20/2016)

---

Hello,

Found Powershell script in below blog to list the last install date and time for windows updates on servers.

https://gallery.technet.microsoft.com/scriptcenter/4d70947e-21b1-4a45-9d78-a7198ed55cca

Is there any way we can get SQL server service pack,hotfix...

frederico_fonseca (12/20/2016)

---

I did use it on...

Have you tried using this? How did it go?

When looking through a long, complex stored proc that was written by someone else, I find it soooo helpful to see approximately one third of all the code commented out,...

Agnii (12/19/2016)

---

Hello All, Trying to import 2 billion rows text file into an empty table in SQL server 2016 using BCP utility and getting the error -"SQL server could...

So you should certainly know how to spell it by now! :hehe:

Thom A (12/19/2016)

---

BrainDonor (12/19/2016)

---

I suppose getting csv files sent isn't an option? It shouldn't be of course but I've already ranted about the delight of Excel files with SSIS in...

Thom A (12/19/2016)

---

Thanks Phil,

I got to step 4, and my error rows were about half of my data set. Exporting that data out showed nothing odd about it, but they...

Thomas LeBlanc (12/19/2016)

---

Sean Peffer (12/19/2016)

---

As per the other comments it easier to maintain the SQL code than SSIS derivation task and probably better to push the load onto the SQL...

Also, I think you need to specify -ServerInstance when using Invoke-Sqlcmd.