Skip to main content

Error creating package (SSIS)

Image
By
I've been wandering with this issue that I've encountered lately when I was about to create a new SSIS package for my project. 


The following screenshots below will demonstrate the scenarios:


In this picture I was trying to create a new SSIS package but then I got this:
"Failed to save package file [directory] Element not found"


And when I was trying to open an existing package I got this error: "Error Creating package" ... "Failed to save package file [directory] Element not found"




Well there's really something wrong ,  probably there might be some prerequisites been missing. For this scenario we have to add the two important DLLs required by the SSIS. The msxml3.dll and the msxml6.dll. 


To do this you have to use command prompt and be in this directory "[DriveName]:\Windows>System" and do the following command:


C:\Windows\System> regsvr32 msxml3.dll 
C:\Windows\System> regsvr32 msxml6.dll 


There will be a notification for each command that has been executed whether the manual installation was successful or not, that confirmation will be in a form of a message box.


Be sure to restart your Microsoft Visual Studio(version 2000 , 2005 , 2008 , 2010...) application before you attempt to create/open an SSIS package.


The following below are the actual screenshots for troubleshooting my issue:


Step 1 : Open the Command Prompt


Step 2: Execute this code : regsvr32 msxml3.dll 


Step 3: Wait for the confirmation that says it was successfully installed before doing this code : regsvr32 msxml6.dll 


Step 4: After the step 3 was successfully confirmed, try now to restart the said IDE and try to create/open an SSIS package project. If the installation is successful this form should appear.


I hope this helps.

Comments

  1. AiryceAugust 3, 2010 at 3:44 AM

    If there will be a problem during the installation of those two dll, try to REPAIR the MSXML 6.0 Parser at the ADD/REMOVE PROGRAMS

    ReplyDelete

Post a Comment

Popular posts from this blog

My Carboxy Stretchmark Treatment and Slimming Wrap experience at Total Skin Care Center

By
I've been googling around about this new treatment being introduced and implemented lately that is called Carboxytherapy that helps to reduce fats, cellulites deposits & even skin stretchmarks in our body.  ===================================== ======================================= According to this site : http://www.carboxytherapy.com/ Carboxytherapy refers to the cutaneous and subcutaneous administration of carbon dioxide gas [CO2] for therapeutic purposes. Carboxytherapy originated at the Royal Spas of France in 1932 with the treatment of patients afflicted by peripheral arterial occlusive disease. In South America and Europe, carbon dioxide therapy has been applied to the treatment of stretch marks, cellulite, and hypertrophic scars with impressive results. Studies have demonstrated that carboxytherapy improves skin elasticity, improves circulation, encourages collagen repair, improves the appearance of fine lines and wrinkles, and destroys localized fatty depos...
14 comments
Read more

MS SQL commands for inserting country list in database

By
I was having a hard time to find a database with complete set of country list and its corresponding nationalities... Although I found some but probably they are for sale... and you need to buy it (>. So what I've only got (from web surfing / researching) was a text file of country list plus their nationalities. So I don't have any option, so I've created a MS SQL query commands that inserts all 192 countries in a database..by just creating a new script , I mean I coded it into an MS SQL queries that inserts into a table(so you won't need to type it (^.~) ). Here is the instructions : 1) Download or copy the Query / Scripts I provided. INSERT INTO COUNTRY([NAME] , NATIONALITY ) values('Afghanistan', 'Afghan') INSERT INTO COUNTRY([NAME] , NATIONALITY ) values('Albania', 'Albanian') INSERT INTO COUNTRY([NAME] , NATIONALITY ) values('Algeria', 'Algerian') INSERT INTO COUNTRY([NAME] , NATIONALITY ) values('Andorra', ...
Post a Comment
Read more

ALERT! : Conficker Worm

By
National Cyber Alert System Technical Cyber Security Alert TA09-088A Conficker Worm Targets Microsoft Windows Systems Original release date: March 29, 2009 Last revised: March 30, 2009 Source: US-CERT Systems Affected * Microsoft Windows Overview US-CERT is aware of public reports indicating a widespread infection of the Conficker/Downadup worm, which can infect a Microsoft Windows system from a thumb drive, a network share, or directly across a corporate network, if the network servers are not patched with the MS08-067 patch from Microsoft. I. Description Home users can apply a simple test for the presence of a Conficker/Downadup infection on their home computers. The presence of a Conficker/Downadup infection may be detected if a user is unable to surf to their security solution website or if they are unable to connect to the websites, by downloading detection/removal tools available free from those sites: * http://www.symantec.com/norton/theme.jsp?them...
1 comment
Read more