RE: Question about datatype mismatches and data transformation Thomas Kennedy 14.Apr.04 01:09 AM Lotus Notes LEI LEI - 6.0Windows 2000
Oops, bad example, I meant to say it won't take datetime-to-text transfer:
Error: Field type mismatch: 'EffectiveDate' Source Connector field is type Datetime, Target Connector field is type Text, Connector 'foo: Notes Foo (Connection)', Method -Update- 04/13/2004 06:12:51 PM Activity Ended With An Error: foo: SQL Server EmployeeDatamart_VW (Transfer)
Unfortunately there are a lot of such datetime field to text field transfers in our Notrix jobs.