Specialized And Data Driven

  • Data Integration Specialist
    • Warehouse integrations
    • ERP service call integrations
  • AX 2012R2 BI Contractor
    • Business Intelligence
    • X++ Developer
    • Security
  • Business Intelligence Systems

Every project I work on is an exercise in efficiency, scalability and integrity.

On April 1st 2015, I will not be accepting new contracts due to my employment status changing to FTE with a Microsoft Partner.

 

Recent Posts

SSIS Expression Convert From IntDate to String

In a SSIS Expression how do you get from 20160101 to 01/01/2016?

Use this command in Derived Column Editor and replace the field that you’re intending to convert.

SUBSTRING((DT_WSTR,8)[TimePeriod],5,2) + “/” + SUBSTRING((DT_WSTR,8)[TimePeriod],7,2) + “/” + SUBSTRING((DT_WSTR,8)[TimePeriod],1,4)

I found several incomplete examples that didn’t include the (DT_WSTR,8) conversions of the int field. This is just to help people who also need int to Date in SSIS.

Cheers.

 

  1. Budget Form for people who need one Comments Off on Budget Form for people who need one
  2. TSQL – Replace URL Escape Characters Comments Off on TSQL – Replace URL Escape Characters
  3. Editing AX 2012 SSRS Report – PurchPurchaseOrder Comments Off on Editing AX 2012 SSRS Report – PurchPurchaseOrder
  4. Could not find [class].[method] in the method map. Will attempt to use X++ delagates. Comments Off on Could not find [class].[method] in the method map. Will attempt to use X++ delagates.