DSXchange

Hi snassimr, You have to specify the value in the new project , and the Default value for the environmental variable will be "PROJDEF" , in this way you donot see the old value in the new project. Hope I am clear ... Suresh Hi ! I have one problem. I build job and define enviroment variabl...

Hi Craig, That was a nice little trick :idea: . Can't we use the Real function in this scenario? If you are sure you have only ' , ' in your column , you can ereplace that with null and check for Num of that field and insert in the Num field. Trim(Ereplace(yourcolumn,',','')) and check this result ...