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

As much as I appreciate your response, please DO NOT reply with "I don't know how to do this". Once you reply to a post others might think the question...

Thanks for your response. I resolved this issue in the following blog...

http://www.sqlservercentral.com/Forums/Topic1776398-1351-1.aspx#bm1776799

Ok, I got it. This is how it's done.

I want to thank everyone for trying to help me out. SSC FTW!!!!

$ServerName = "MilanoMosh"

$ConfigFile = "C:\MyFile.dtsConfig"

function Edit-XmlNodes {

param (

...

I edited my post to reflect the error message.

My bad 😀

Thank you for your response, but the link is not working.

Ok here is the dtsconfig file. I am trying to gain the ability to update the server name and database name.

My idea is to pass Servername and DB name variables...