...
Double click on a Providex table on the Source Objectspanel 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.
...
...
Sage 100 Date Issues
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Related Pages
...
Sage 100 Technical Details – issues addressed in more depth
ETL+ for Sage 100 Providex – more pages in this section
From Sage
Sage 100 PxPlus Reference Manual / Providex – Guide to finding SQL documentation in this reference manual.
http://manual.pvxplus.com – Link to the reference manual itselfETL+ for Sage 100 Providex