{"id":48,"date":"2013-12-06T18:47:00","date_gmt":"2013-12-07T00:47:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=48"},"modified":"2013-12-06T18:47:00","modified_gmt":"2013-12-07T00:47:00","slug":"error-ssis-an-error-prevented-the-view-from-loading","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=48","title":{"rendered":"ERROR : SSIS : An error prevented the view from loading."},"content":{"rendered":"<div style=\"background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin: 0in 0in 10pt;\">\n<b>ERROR :<\/b><u><\/u><u><\/u><\/div>\n<div style=\"background-color: white; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin: 0in 0in 10pt;\">\n<span style=\"color: #990000;\"><b>SSIS (v9) :&nbsp;An error prevented the view from loading.&nbsp;&nbsp; The specified module could not be found (Exception from HRESULT : 0x8007007E) (System.Windows.Forms)<\/b><\/span><span style=\"color: #222222;\"><u><\/u><u><\/u><\/span><\/div>\n<div style=\"background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin: 0in 0in 10pt;\">\n<b>CAUSE :<\/b>&nbsp;&nbsp;<\/div>\n<div style=\"background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin: 0in 0in 10pt;\">\nThis error occurs in the designer when opening SQL Server Business Intelligence Studio after upgrading to VS 2010 or 2013, .&nbsp; While upgrading Visual Studio, DLL files are upgraded in the MSDesigners8 folder causing the graphical designer to fail.<u><\/u><u><\/u><\/div>\n<div style=\"background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin: 0in 0in 10pt;\">\n<b>RESOLUTION :&nbsp;&nbsp;<\/b><\/div>\n<div style=\"background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin: 0in 0in 10pt;\">\nReplace your MSDesigners8 folder with the older version:<u><\/u><u><\/u><\/div>\n<div style=\"background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;\">\n<u><\/u>1.<span style=\"font-family: 'Times New Roman'; font-size: 7pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><u><\/u>Locate a machine where SSIS designer works and copy the folder:&nbsp; C:Program FilesCommon Filesmicrosoft sharedMSDesigners8<u><\/u><u><\/u><\/div>\n<div style=\"background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;\">\n<u><\/u>2.<span style=\"font-family: 'Times New Roman'; font-size: 7pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><u><\/u>Navigate to the problematic machine to verify that your files on C:Program FilesCommon Filesmicrosoft sharedMSDesigners8 differ in version.<u><\/u><u><\/u><\/div>\n<div style=\"background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;\">\n<u><\/u>3.<span style=\"font-family: 'Times New Roman'; font-size: 7pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/span><u><\/u>Backup your current MSDesigners8 folder, delete, and then copy the older version.<\/div>\n<div style=\"background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;\">\n<\/div>\n<div style=\"background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;\">\n<b>MSDesigners8 :&nbsp;<\/b><\/div>\n<div style=\"background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;\">\n<\/div>\n<div style=\"background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;\">\nFeel free to email me for a copy of this folder if you cannot download it here:<\/p>\n<p><a href=\"https:\/\/drive.google.com\/file\/d\/0B1uCy4dPyCNXZGxoNXlvdUhYTGc\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener\">msdesigners8<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>ERROR : SSIS (v9) :&nbsp;An error prevented the view from loading.&nbsp;&nbsp; The specified module could not be found (Exception from HRESULT : 0x8007007E) (System.Windows.Forms) CAUSE :&nbsp;&nbsp; This error occurs in the designer when opening SQL Server Business Intelligence Studio after upgrading to VS 2010 or 2013, .&nbsp; While upgrading Visual Studio, DLL files are upgraded &hellip; <a href=\"https:\/\/www.chrystalsander.com\/blog\/?p=48\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;ERROR : SSIS : An error prevented the view from loading.&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/48"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=48"}],"version-history":[{"count":0,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/48\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}