its looking more and more to me like vs's list of "add in/macros security" paths isnt turning up the necessary xml file where the key to finding system.data (framework's...

sure.

When indicating conn mgr is new in edit mode on destination component in data flow, "the new connection manager could not be created. Additional Information: The DbProviderFactories...