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