I've had to backwards convert my SSIS 2008 package to 2005 including converting all the C# script tasks to VB. After finishing this and getting it to run fine from Visual Studio, I went to deploy it to the server but when I import the package through SSIS into the 'File System' I get the following error:
我不得不将我的SSIS 2008软件包向后转换为2005，包括将所有C＃脚本任务转换为VB。完成此操作并使其从Visual Studio运行正常后，我将其部署到服务器，但是当我通过SSIS将包导入“文件系统”时，我收到以下错误：
Failed to load XML from package file "C:\filePath\packageName.dtsx" due to error
0xC00CE513 "Whitespace is not allowed at this location. Line 7595, Column 82".
This happens when loading a package and the file cannot be opened or
loaded correctly into an XML document. This can be the result of either providing
an incorrect file name to the LoadPackage method or the XML file specified having
an incorrect format. ({EBEB7947-B9DA-4715-B7F7-D1E9CC8DAD6E})
Now when I open the package file up and go to that line this is what I have:
现在，当我打开包文件并转到该行时，这就是我所拥有的：
Dim logFilePath As String = Dts.Variables("LogFolder").Value.ToString() & "\LOG.txt"
Ive tried googling for the past hour and haven't been able to find anything, would really appreciate some help.
我已经尝试了谷歌搜索过去的一小时，并没有找到任何东西，真的很感激一些帮助。
1 个解决方案
#1
1
This has been resolved now. The issue was with copying the package through an RDP session via the clipboard, which for some reason was causing the file to become corrupt. I fixed this by mapping a drive and copying it through that way instead, the original XML from the compiled package was well formed
这已经解决了。问题是通过剪贴板通过RDP会话复制包，由于某种原因导致文件损坏。我通过映射驱动器并通过这种方式复制它来修复此问题，编译包中的原始XML格式正确
#1
1
This has been resolved now. The issue was with copying the package through an RDP session via the clipboard, which for some reason was causing the file to become corrupt. I fixed this by mapping a drive and copying it through that way instead, the original XML from the compiled package was well formed
这已经解决了。问题是通过剪贴板通过RDP会话复制包，由于某种原因导致文件损坏。我通过映射驱动器并通过这种方式复制它来修复此问题，编译包中的原始XML格式正确