rename dtsx package and its impact

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,

I am new to SSIS.

I have a dtsx pckage in production and now we got new requirements to change two column mappings only. I will change the two columns mapping in dev environment and tested ,every thing fine

Now my question is ,how to redeploy it into production ?

Should I change the config file again ? (I have not changed any configuration)
or should I replace the old package with new modified package is enough?

Can any one please explain little more in depth of deployment of SSIS packages (new and existing packages ).It would be good help for beginners

Posted 18-Nov-14 7:01am

pratap420

Updated 18-Nov-14 7:08am

v2

Add a Solution

Comments

PIEBALDconsult 18-Nov-14 13:42pm

Aside: If at all possible upgrade your version of SQL Server -- SQL Server 2012 has a lot of improvements to SSIS.

I have forgotten how deployments are done 2008, but I recall that it was painful.

Shweta N Mishra 19-Nov-14 4:08am

you should be able to do that by replacing it. you can try the same thing in your development too. If that works then you are done. DO the same thing in production.

pratap420 19-Nov-14 5:26am

In development environment we are not using XML config file .We are passing paths,values through variables by manually.Even my job has to execute by manually only

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Lolo1986 · Accepted Answer · 2014-11-26T11:30:00

Solution 1

You should be able of doing this just by replacing your DTX file. The config file is here only to replace data into your SSIS package at the beginning. Doesn't look like you added new variables so just replacing the actual file should be good. Take a backup of the DTSX file before ;)

Posted 26-Nov-14 11:30am

Lolo1986