DSXchange

this can be done using the muti insert staement .so give the parent table first and then child .and handle rejetcts too.

hello,

convert in correct format .You have ''2050-12-31' .but while conveting it into StringToDate(Ln_To_TRF.CHABIM,"%yyyy%mm%dd") .It should bas as StringToDate(Ln_To_TRF.CHABIM,"%yyyy-%mm-%dd") .

Check format correctly

hi ,
thanks for your reply. Could you please elaborate on this

Hi All,

Could any body let me know how to use the Zip command in Execute Activity stage .My requirement is that in a particular directiry i have two files say sample_Abc.txt and other is sample_def.txt .

one option is to set in manually in other environment . other one is to export the .msg file of current environment to other .refer documention for more info

you should check step by step.First remove all the -,'/' and bring it to one format i.e DDMMYYYY,then convert the also DMMYYYY using stage varible .After that do a date validation to check whether it is a valid date or not.

hi,

when you create a message handler for a job,it automatically imports along with your .dsx file

hi,

when you create a message handler for a job,it automatically imports along with your .dsx file

yes we can pass it after job sub routine also.

here is the command line prompt to get list of JObs.

dsjob -ljobs <Project NAME>

have you tried by declaring the data type as NVarchar.i guess this error is due to special characters in that particular column value.

hello,

use the data type as Nvarchar.

hi,

give a try by taking datatype as Nvarchar without defining length.Hope it will work

Hi All,

Is there any option for retreiving multiple records based on key values in merge stage.In lookup we can do it ,by selecting muliple row option.Please throw some ligth on this whether it is possible for merge stage also

Thanks in advance

it would be the hash partioning based on the keys .Try this