Monthly Archives: May 2012

Oracle Date issues with PowerPivot

Posted on May 29, 2012 by MikeDavisSQL

This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the below error when trying to import: OLE DB or ODBC error: Accessor is not a parameter accessor.. Out of line … Continue reading →

Posted in powerpivot, Syndication | Tagged , | Leave a comment

SSIS 2012 Copy or Duplicate Environments

Posted on May 2, 2012 by MikeDavisSQL

In SSIS 2012 there is a great new feature called environments. They can be thought of as a collection of parameters or variables. One of the questions I get asked when teaching SSIS 2012 is “Can I duplicate an environment?”. There … Continue reading →

Posted in SSIS, Syndication | Tagged , | 10 Comments