Error creating package - Failed to save package file
I have Windows Server 2008 R2. I had just installed SQL 2008 SP1 Dev Ed. on my box and got an error message when I tried to create a package using the BI IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again. Following is the text of the error details: =================================== Error creating package (Microsoft Visual Studio) =================================== Failed to save package file "C:\Users\<UserName>\Local Settings\Temp\2\tmp8C4E.tmp" with error 0xC020207E "The file name is not valid. The file name is a device or contains invalid characters.". ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events) at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.SaveToTempFile(Package package) at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.AddPackageToProject(Package package, String itemName) at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.CreateAndAddPackageToProject() at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.Execute(WizardInputs wizardInputs) =================================== Failed to save package file "C:\Users\<UserName>\Local Settings\Temp\2\tmp8C4E.tmp" with error 0xC020207E "The file name is not valid. The file name is a device or contains invalid characters.". ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToXML(String FileName, IDTSPersist100 pPersistObj, IDTSEvents100 pEvents) at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events) I found a similar post that suggested that they try the following: regsvr32 msxml3.dll regsvr32 msxml4.dll regsvr32 msxml6.dll I do have msxml3.dll and msxml6.dll and I registered it. But still i am not able to add new package. Any Help Appriciated..!!! One more thing is, I did not find path "C:\Users\<UserName>\Local Settings\Temp\2\tmp8C4E.tmp" on my box. It seems that Microsoft has invented something called "Junctions" :( . Thanks, Nimesh Parikh
October 20th, 2010 10:08pm

I see some VERY interesting information in that error dump that indicates you have both SSIS 2005 and SSIS 2008 installed on your machine there. Is that possible? You should be able to have both installed side-by-side... but perhaps one of those installs was incomplete or interrupted? Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 2:59am

Hey Todd, I am positive that i took fresh machine and i have install only SQL Server 2008 Developer Ed. Even i pointed out same thing by "Dts90WizardSaveNewTask" and "IDTSEvents100". But than i thought Error throuwn from SaveToXML function so i ignore it. I am very sure that i have not installed SQL Server 2005. Do you thing there might be some problem with SQL Setup..? I am able to create SSAS / SSRS projects. Apriciate your help. Nimesh
October 21st, 2010 6:24am

Any Help...??????
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 5:22pm

Can you examine your "add/remove programs" to see if you have 2005 installed? Can you examine your file system and services lists to see if there appear to be 2005 components running? Talk to me now on
October 22nd, 2010 6:48pm

Hey Todd, I have checked and I did not find any 2005 component. neither in programs nor in services One more Strange thing i have found : In my installed programmed list, i did not found msXML6.0. When i tried to install it, it gives me message that MSXML 6.0 has installed successfully. When I tried to uninstall / repair it, error message comes saying “This functionality valid only for installed component” J I have found MSXML6.0 dll to in my system32 Crazzy..!!!!
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 10:37pm

Can you try and "repair" your SQL install - or uninstall and reinstall? Talk to me now on
October 23rd, 2010 12:15am

Well, I have already tried it..!!!! No Luck...!!!!! :(
Free Windows Admin Tool Kit Click here and download it now
October 23rd, 2010 12:25am

Hi Nimesh, By default, the user variable for TEMP points to %USERPROFILE%\AppData\Local\Temp. In this case, the TEMP pointed to %USERPROFILE%\Local Settings\Local\Temp in your environment. This is incorrect. By design, users are restricted direct access to Local Settings folder. This should be the cause why we can't save the package file. In order to solve the issue, please follow these steps: Open 'Control Panel' Double-click 'System' Click 'Advanced system settings' Click 'Environment Variables...' Select 'TEMP' from 'User variables for <account>' Click 'Edit' Change the value to be ' %USERPROFILE%\AppData\Local\Temp' Save the setting Now, we should be able to save the package. Please note, there should have a domain level policy, which may reject us to change the setting. If so, please ask your domain administrator a help to change the setting. If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
October 25th, 2010 5:47am

Hi Jin, That works for me, I could have spot it :) Thanks a ton..!!! Nimesh
Free Windows Admin Tool Kit Click here and download it now
October 25th, 2010 11:04pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics