The file name is not valid. The file name is a device or contains invalid characters
Hi All, I created a package in a solution yesterday and for some reason it did not show up in the solution that I created it in. I tried to attach the package to the solution by going through Add Existing Package, but its giving me the error "Failed to save package file "C:\Documents and Settings\xxxx\My Documents\Visual Studio 2008\Projects\XXXX_Tables\XXXX_Tables\pkg_ETL_TK_Register_Schema_Landing.dtsx" with error 0xC020207E "The file name is not valid. The file name is a device or contains invalid characters". This is also happening when I am trying to open a package that is deployed on the server, by going through the same Add Existing Package but again it is giving me the same error "Failed to save package file "C:\Documents and Settings\xxxx\My Documents\Visual Studio 2008\Projects\XXXX_Tables\XXXX_Tables\pkg_ETL_TK_Register_Schema_Landing.dtsx" with error 0xC020207E "The file name is not valid. The file name is a device or contains invalid characters", but when my colleague goes and does the same thing, the package opens and it works. I am unable to find out why this is happening, could anyone please help me with this. Thanks Vineeshvineesh1701
May 8th, 2012 1:19pm

It could be I am thinking the length of the path. Try to create a new solution on say C:\Test drive/folder and then bring this package. If works, you know why.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2012 3:00pm

Copy the file name from package and try in windows explorer and see the file path is correct. ESHANI. Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you
May 8th, 2012 9:52pm

Hi Eshani Rao, Please try to register MSXML6.dll on your machine, follow these steps: 1. From the Start menu, click Run. 2. Enter the following command: regsvr32 %windir%\system32\msxml6.dll. 3. Click OK. And here is a similar thread, please refer to atulpatel.mca's reply in the following link: http://www.sqlservercentral.com/Forums/Topic594726-148-2.aspx Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
May 14th, 2012 4:19am

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

Other recent topics Other recent topics