Neal Waterstreet

  • Home
  • About
  • Book Reviews
    • 2018 Reading List
    • 2017 Reading List
    • 2016 Reading List
    • 2015 Reading List
    • 2014 Reading List
    • 2013 Reading List
  • Projects
    • OBi200
    • DS716+ memory upgrade
    • Cord cutting
  • Presentations
  • Contact

Archives for March 15, 2018

Default value for “ErrorCode”

March 15, 2018 by neal Leave a Comment

MDS 2016 is a big improvement over the previous versions. There are many enhancements in almost every area. One change I had not noticed in MDS 2016 is that a default value has been added for the “ErrorCode” attribute in the staging tables.

One situation where this may be an issue is when SSIS is used to stage data. If the “Keep nulls” value is checked in the Destination configuration, the insert will result in an error.

Filed Under: MDS, SSIS Tagged With: Entity-based staging, Leaf Tables

March 2018
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Feb   Apr »

Blogroll

  • Atlanta MDF
  • Atlanta Microsoft Business Intelligence Group
  • Atlanta Modern Excel User Group
  • Chris Webb's BI Blog
  • codegumbo
  • Lance England
  • PowerPivotPro
  • Prologika
  • SQLBI

Tags

#SQLSatATLBI Aereo at Atlanta Microsoft BI Azure Azure DataFest Backups Batch Certification changeset Chicago Conference CrashPlan Data Modeling Data Quality DAX Deployment DVR Entity-based staging Error Messages Excel Filter Goals Headphones Healthcare Leaf Tables MDM MDS MDS Add-in for Excel Oops! Something went wrong PASS Healthcare VC Power BI Power Pivot review Roku SQLSaturday SQL Saturday 800 SQLSaturday Atlanta BI SSIS Streaming Subscription View Time Training Validation Version Flag

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2025 · Minimum Pro Theme on Genesis Framework · WordPress · Log in