Excerpt |
---|
How to configure the ETL+ Design Page to process bad dates in date fields from Providex data sources. |
ETL+ Design page Page will convert data from Sage 100 Providex to a format usable on ETL+ data warehouse (a Microsoft SQL Server database).
Double click on a Providex table on the Source Objectspanelif IF
the table hasn’t yet been added to the Target Objects panel.Select the target table on the Target Objectspanel.
Select Design.
For the date columns in the target table:
Select the VarChar checkbox.
Change Dw Data Type to datetime.
ETL+ will generate and enter a appropriate T-SQL Expression.
...
Related Pages
Sage 100 PxPlus Reference Manual / Providex – Guide to finding SQL documentation in this reference manual.
http://manual.pvxplus.com – Link to the reference manual itself