Hi, I have developed a few packages but deploying them is always a problem. I have read quire a few posts on this but none of it give a proof solution. I need to put configurations for package in database table. I have provided environment variable and database configuration option to the package. Now, I do not know what options to set for encryption. If i don't then connection throws an error. If I provide it then xml node decryptuion error is thron. Can someone guide me the logic and step by step instruction to deploy a package in production/test environment from devvelopment machine. Thanks in advance.Shady

In general, to avoid most of the package deployment errors from one system to another system, set package protection level to ‘DontSaveSenstive’. This should not generate any errors. I cant provide step by step at this time, but maybe later in the day or tomorrow.

In general, to avoid most of the package deployment errors from one system to another system, set package protection level to ‘DontSaveSenstive’. This should not generate any errors. I cant provide step by step at this time, but maybe later in the day or tomorrow.

Hi Raminder, you can also use dtutil utility (http://msdn.microsoft.com/en-us/library/ms162820.aspx).Regards, Sifiso W. Ndlovu | Data Analyst| Nedbank Group Ltd Nedbank Head Office, 135 Rivonia Road, Sandown, 2196 South Africa

Hi Raminder, you can also use dtutil utility (http://msdn.microsoft.com/en-us/library/ms162820.aspx).Regards, Sifiso W. Ndlovu | Data Analyst| Nedbank Group Ltd Nedbank Head Office, 135 Rivonia Road, Sandown, 2196 South Africa

Hi, Realised my mistake in logic. I was trying to set connection string configuration from environment variable as well as database table.Shady

Hi, Realised my mistake in logic. I was trying to set connection string configuration from environment variable as well as database table.Shady

Hi, Realised my mistake in logic. I was trying to set connection string configuration from environment variable as well as database table.Shady