DSXchange

I am still getting the same output.

Anbu, Do you mean
If Len(Trim(DSLink35.date_opened) = 0) Then ''" Else StringToTimestamp(DSLink35.DT_OPENED,"%yyyy-%mm-%dd %hh:%nn:%ss")

I have an input field as below date_opened 2010-01-05 13:14:16.130 I am reading it as a Varchar and I have also tried Varchar(26). In my transformer I use : StringToTimestamp(DSLink35.date_opened,"%yyyy-%mm-%dd %hh:%nn:%ss") My output is a sequential file and the column is defined as a tim...

It could grow to more than 100 over the next few releases.

Hello,

I have a situation wherein I need to read 20 different source tables and load them into 20 different target tables all with varying metadata.
Both my source and target are SQL Server Databases.
How can I minimize the number of jobs and accomplish this task.

I know that join can be used to combine data from two different sources but what about these 2 records which come from the same table?