DSXchange

Using WeekdayFromDate function you can get the day in numbers(0 to 6)

Write a stage variable like
if the monthfromdate(your_date)>2 and yearfromdate(your_Date)/4=0 then do -366 using DateFromDaysSince
else
-365 days

please inform us if you get any other solution

This could be the problem with credentials.

You might have given some wrong credentials

Try to give same username information for both the DS and DB servers

Thanks,
Sreekanth

Create stage variable by using length function

If Len(input_column)=1 then Y else N

then put the stagevariable=Y for target and N for reject

Thanks,
Sreekanth

Yes Craig, my Menu Bar is back now

A __ 1 2 5 6 B __ 3 4 7 connect your source A records to Transformer by adding a sequence number using Surrogate Key generator stage then your source A data in transformer look like below sno,A _____ 1,1 2,2 3,5 4,6 Do the same thing for second source also and connect to another transformer then the...

I think the following Stage variables will help you svNextMonth - If ( Compare(MonthFromDate(Input_Date),'12') = 0 ) Then '01' Else DecimalToString( (StringToDecimal(MonthFromDate(Input_Date)) + 1) ,'suppress_zero') svNextMonthDate - If ( Compare(MonthFromDate(Input_Date),'12') = 0 ) Then DecimalToS...

1. Process your source data into two flows(mainflow and change flow) from transformer stage 2. add dummy=1 in tranformer for changed flow 3.put sort stage in changed flow by sorting on the 3 columns(key,f1 and f2) 4.put filter using the condition f1=f2=N, then the output of this stage will be having...

Yes, Full outer join will solve your problem
I agree with ray's reply

Thank you Craig, i got the other links

Sreekanth

File,Edit,View,Diagram,Debug,Tools,Window,Help options are not visible