Archives: May 2012
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