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...

Going to try it with Environment Variables, thanks as always 😀

Hi Phil,

If you are using integrated security, what security issues concern you?

I guess my question should be... "What types of security issues will I have to concern myself with using...