since you have CMS set up, I would use a powershell script to poll each CMS server, and insert data into a centralized table.

then you could generate an SSRS report...

the example here:

http://ss64.com/nt/syntax-delolder.html

is so close to your version, i'm not sure there's an issue:

the only thing i see is that the example uses slashes instead of hypens for the...

my example contained the word [ColumnList] as a placeholder for...

Phil Parkin (12/16/2016)

---

Glad you solved it. Not sure whether you know this, but if you add

using System.IO;

into your Using block (towards the top of your code module)

it allows you to...

you said find duplicates in the first post.

INTERSECT finds...

i always put my audit table in the master database, since it is guaranteed to exist, and all logins inherit some access to it.

someone already mentioned the three part insert:...

it depends on what you define as a duplicate; a few columns, or every column, including identities and CreatedDates?

also, is a duplicate in two databases, or must be in ALL...

I know the default is to search for a local windows user related to the server name;

You probably need to change toe location to to browse to find the...

mandavli (12/16/2016)

---

it is UNC path that I am using in the package,

with fail as I mean it's not able to find file, even if I have same proxy accounts...

mandavli (12/16/2016)

---

Thank you. Created the proxy and it worked on the native server (where the catalog exists)

But when I create a job on a different sql server. it fails, I...

did you already configure a credential and proxy operator in SQL Agent?

Did you configure that step to use that proxy operator?

the account that runs the SSIS jobs \is often a...

both examples were extremely helpful, folks, thank you!

I did it both ways as my proof of concept; I was already leaning towards Phil's example of a script task, but I've...

the key is to generate all possible combinations first..

Basically, you have to select from Your Calendar/Dates table,and cross join all possible employees, and then finally left join it to attendance.

WHERE...

what you are looking for is a Cartesian Product;

also known as a cross join

the syntax is pretty simple:

SELECT * FROM #Table1

CROSS JOIN #Table2

in the future, if you want the...

dndaughtery (12/13/2016)

---

Hey guys, I'm using an execute process task to unzip a password protected zip file. I'm able to unzip and create the file in the target folder but it...