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

Hi Phil - I am using 2014. Which other methods do you recommend for this?

Thanks for your reply.

I am trying to create a Report for my Manager which shows a chart of Users who ran most number of queries in the last 24 hours....

I figured that the tools will not convert everything. I am hoping to get some assistance since I haven't used PL/SQL since Oracle 8i.

Thank you all so much for your...

Phil,

We are going to recreate the ControlM jobs manually due to the complexity of the processes, so this make my life easier somewhat, tedious, but easier.

Thanks for you help as...

Hi Phil,

If there is a way that I can separate the tags, maybe I can wrap this in dynamic SQL. I am thinking something like...

@var = 'Create Job'+<NAME TAG>, etc,...

Thanks Luis.

SQLTougherGuy (9/28/2015)

---

Hello,

I inherited an SSIS package that is rather simple. It grabs data from a SQL Query and then loads it into a SQL table. The first step of this...