Hi Thom,

Thanks for this. Yea, I am struggling with this a bit.

Basically, I need to find Users that are on for 24 hours, with no inactive...

Thanks Lowell.

Is this supposed to be a shared drive? Can it work without? My companies security is locked down, unfortunately.

I will check that out and thank you.

Thank you all for your responses. Being in this industry, I have, of course heard the acronym RTFM. It just makes people feel like they haven't done their research, which...

Wow, I didn't expect hostility. I have been "RTFM", that is why I am asking for help. I love this site (until you responded), and I was hoping someone had...

Thanks!

Hi Phil,

So my script will have a one second delay before kicking off each job?

Thanks

Can you give me an example of... "simply have one task for each statement on the same schedule".

I am not sure what you mean or how to do this.

Thanks again!

Thanks guys!

Luis - The command-line that I provided will be executed from SQL Agent. From what my boss has told me, re engineering these Oracle packages to SSIS is going to...

Is there a way to SELECT the full data source from SSMS?

Found the solution on MSDN forums:

[xml] $config = get-content "yourxmlfile.xml"

$item = $config.properties.property | ? { $_.name -eq "Reports.DMV.TNSEntry" }

$item.value = "Data Source=...."

Set-Content "yourxmlfile.xml" -Value $config.InnerXml -Force