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 object Datasource referring to id ….

Out of line object… Read more

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 is a move feature already included. But this moves… Read more