Sage 100 Providex Dates

Owned by Cortlandt _
Last updated: Dec 21, 2023
1 min read

How to configure the https://dataself.atlassian.net/wiki/spaces/DS/pages/1637023747 to process bad dates in date fields from Providex data sources.

https://dataself.atlassian.net/wiki/spaces/DS/pages/1637023747 will convert data from Sage 100 Providex to a format usable on ETL+ data warehouse (a Microsoft SQL Server database).

  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.

 

For issues this page doesn’t address.