So I had my dose of mild frustration followed up by a funny this morning.

A dev asked me to restore two Test 2012 databases down to SQL 2k8. As I'm...

I think I found what I needed. I will know when I've tested it.

From BOL on Integration Services job steps:

Use 32 bit runtime

Indicate whether to run the package...

Can someone help me with "hacking" the Script Job As Drop code?

I don't really want to hack MS's version so much as look at it and adapt it to my...

Eirikur Eiriksson (4/29/2016)

---

BLOB_EATER (4/29/2016)

---

GilaMonster (4/29/2016)

---

GilaMonster (4/27/2016)

---

BLOB_EATER (4/27/2016)

---

GilaMonster (4/26/2016)

---

BLOB_EATER (4/26/2016)

---

GilaMonster (4/26/2016)

---

SQLRNNR (4/26/2016)

---

The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from...

I hope you're not giving up because of what I said. The intent was not...

GilaMonster (4/29/2016)

---

GilaMonster (4/27/2016)

---

BLOB_EATER (4/27/2016)

---

GilaMonster (4/26/2016)

---

BLOB_EATER (4/26/2016)

---

GilaMonster (4/26/2016)

---

SQLRNNR (4/26/2016)

---

The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to...

mbraman (4/28/2016)

---

So the total is 700 not 1400.

The data flow is - data in sql server goes to tabular model to tableau.

The "Field..." are filters in table.

So what...

MSDN article on scripting variables with SQLCMD: https://msdn.microsoft.com/en-us/library/ms188714.aspx

Dave Pinal's thoughts[/url] on the subject.

DBA Stack Exchange http://dba.stackexchange.com/questions/13860/how-to-pass-in-parameters-to-a-sql-server-script-called-with-sqlcmd

So, if I understand this correctly, you can use the SQLCMD code to pull the...

Grant Fritchey (4/28/2016)

---

Brandie Tarvin (4/28/2016)

---

Grant Fritchey (4/28/2016)[/b]

---

Technical question:

I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to...

Grant Fritchey (4/28/2016)[/b]

---

Technical question:

I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...

Grant Fritchey (4/28/2016)

---

Brandie Tarvin (4/28/2016)

---

Grant Fritchey (4/28/2016)

---

Technical question:

I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to...

Grant Fritchey (4/28/2016)

---

Technical question:

I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...

TomThomson (4/26/2016)

---

Trains? UK rail fares are by far the...

I just remembered. There was so...

Steve Jones - SSC Editor (4/26/2016)

---

wow, deny to public. That would have been low, low on my list.

Good catch, Brandie.

I hate anyone that adds any permissions to public. Please, please,...