Sage 100 Providex Dates

How to configure ETL+ to process bad dates in date fields from Providex data sources.

1. Double click on a Providex table on the Source Objects panel if the table hasn’t yet been added to the Target Objects panel.

2. Select the target table on the Target Objects panel.

3. Select Design.

4. For the date columns in the target table:

   1. Select the VarChar checkbox.

   2. Change Dw Data Type to datetime.

ETL+ will generate and enter a appropriate T-SQL Expression.