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

What does the Bible says about Marriage?

By
For those people, especially married couples, who seeks God's advice or guidance about Marriage. Here are some bible passages that you can read and internalize the quintessence of His words.  I do hope that by sharing this e-book, it could help someone or couples to enlighten and improve their relationship with God as a couple  AND  the relationship of the married couple(s) itself. This e-book can be read on your smart phones and/or computers  with installed *. pdf file app reader on it. Here's the preview e-book cover of " What does the Bible says about Marriage ? ".   Get & purchase this e-book at the e-store below: Once your payment has been successfully processed. You will receive an e-receipt order form followed by another e-mail containing instructions on how to access the actual e-book itself. Thank you and God Bless, Grace
Post a Comment
Read more