If you are using standard logins to connect to SQL Server these items are lost when you save and deploy the package. You need to change the settings for the package security level. This can be done on the Properties for the package under Security | ProtectionLevel. One option is to use DontSaveSenstive...

hi, while importing data from excel to sql table in DTS i am getting the following error. general conversion error on column pair(source column(DBTYPE_WSTR),destination column(DBTYPE_NUMERIC)) sample (excel) input cap 24% to the table data type decimal thanks in advance

harni@voila.fr , Can you please translate the error message from French to English? I want to see if we can give you a hand on this item. Thank you, The MSSQLTips.com Team