Maybe you're not looking in the right place. Try running this query:

select name, type_desc, physical_name

from sys.database_files;

Then look in the path/file in the physical_name.

Maybe the DBA didn't set...

djackson 22568 (8/21/2015)

---

Reality - Company wants to implement a new software package that will handle payroll, HR, procurement, AP, AR and GL. Vendor tells company it will require 30...

I'm required to go through security training and take (and pass) a test every year. It isn't anything new and pretty basic stuff, considering what I do every day....

Phil Parkin (8/21/2015)

---

Luis Cazares (8/21/2015)

---

Ed Wagner (8/21/2015)

---

Brandie Tarvin (8/21/2015)

---

Phil Parkin (8/21/2015)

---

Ah yes, tried to take a sneaky shortcut. Needs to be fixed:

and sjh.run_date >= (year(getdate() - 1) * 10000 +...

Yes, a very good guess. That would be the simplest one to handle, so let's hope for that one. 😉

So, the list is now:

A. April 1981 (M/YYYY)

B. April 19,...

Luis Cazares (8/21/2015)

---

Ed Wagner (8/21/2015)

---

Brandie Tarvin (8/21/2015)

---

Phil Parkin (8/21/2015)

---

Ah yes, tried to take a sneaky shortcut. Needs to be fixed:

and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() -...

Another question is how to determine rows considered duplicates. Normally, this would be any row that has identical values in one column, but you're saying that 1234567 and 1234567A...

So what date does 41981 represent?

A. April 1981 (M/YYYY)

B. April 19, 1981 (M/DD/YY or M/D/YYYY)

C. December 8, 2014 (Excel integer...

Brandie Tarvin (8/21/2015)

---

Phil Parkin (8/21/2015)

---

Ah yes, tried to take a sneaky shortcut. Needs to be fixed:

and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() - 1) * 100 +...

As others have pointed out, if you're working on this query, you need to understand how it works. After all, you're going to be the one supporting it. ...

I don't really use the BI tools much, but it was able to be researched. Thanks, Steve.

Honor

Breach

Jack Corbett (8/20/2015)

---

Sean Lange (8/20/2015)

---

I typically do it using t-sql myself but in this case SSIS just makes sense because the data is coming from so many places....

Sean Lange (8/20/2015)

---

Ed Wagner (8/20/2015)

---

Sean Lange (8/20/2015)

---

Agreed 100% that the other way should be an issue but seriously...the best part was I spent the better part of an hour trying...