Click here to Skip to main content
14,425,156 members
Rate this:
Please Sign up or sign in to vote.

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
Updated 18-Nov-14 8:08am
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

Rate this:
Please Sign up or sign in to vote.

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 ;)

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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100