December 4, 2013 at 6:51 am
Hi. We run 2012 enterprise with vs2010. I have inherited a w7 machine whose vs 2010 installation seems to have all the SSIS tool box items but complains when trying to save an oledb destination saying system.data (or from other angles data providers) cant be found. I dont see anywhere in vs2010 (shell) to set references. I do believe i see various .net framework 4 features installed on this machine. Does the communityy believe some part of the framework wasnt installed? Or maybe vs wasnt installed completely? Or maybe I need to do something in GAC? Flat file connector seems fine. This is my first real dive into vs2010. Previous experience is with bids 2008 which as i recall was installed right off the sql media.
December 4, 2013 at 9:03 am
stanteitelbaum (12/4/2013)
Hi. We run 2012 enterprise with vs2010. I have inherited a w7 machine whose vs 2010 installation seems to have all the SSIS tool box items but complains when trying to save an oledb destination saying system.data (or from other angles data providers) cant be found. I dont see anywhere in vs2010 (shell) to set references. I do believe i see various .net framework 4 features installed on this machine. Does the communityy believe some part of the framework wasnt installed? Or maybe vs wasnt installed completely? Or maybe I need to do something in GAC? Flat file connector seems fine. This is my first real dive into vs2010. Previous experience is with bids 2008 which as i recall was installed right off the sql media.
Hi - it would probably be helpful if you were to post the full error message.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
December 4, 2013 at 9:18 am
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 section can only appear once per config file".
When rt clicking in conn mgr tab and choosong new oledb conn, "The new connection manager could not be created. Additional Information: Unable to find the requested .Net Framework Data Provider. It may not be installed. (System.Data)"
December 4, 2013 at 1:15 pm
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 sql data layer class) is supposed to be found. I see this list of 7 token based paths under tools->options...
my head is spinning a bit but the few paths i could figure out and follow showed no .addin extension xml files. I am not sure if a repair or reinstall (or something else like an environment variable change) is indicated here. From what I read, this stuff is supposed to be set up automatically at install. And therefore something a developer like me doesnt want to touch.
December 4, 2013 at 2:37 pm
repairing (without uninstall) just vs2010 from the installer didnt do the trick. Back to the drawing board.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply