August 2, 2010 at 7:52 am
I have an SSIS package (written by another person)that has been running for sometime now in Production. I need to change a value in one of the variables. After I change the variables do I need to deploy the package again for the changes to take affect ?
If so can someone tell me the steps for the deployment. Thanx in Advance !
August 2, 2010 at 10:19 am
Sanz (8/2/2010)
I have an SSIS package (written by another person)that has been running for sometime now in Production. I need to change a value in one of the variables. After I change the variables do I need to deploy the package again for the changes to take affect ?If so can someone tell me the steps for the deployment. Thanx in Advance !
If the variable is mapped in the SSIS config. file then you dont need to deploy the package. You can add the new value to the config file. Otherwise you need to modify the package and change the value to the variable.
Also for deployment, it depends on how the package was promoted to production earlier. If this was promoted as file copy then you can overwrite the existing package by overwriting the existing package with the new one.
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply