×

Loading...
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。

here is the error message when I run the new dtsx that was copied over

Message
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 5:27:47 PM
Error: 2011-08-05 17:27:48.11
Code: 0xC0011009
Source: {4A25AD3F-9118-40FE-9A9B-0CEF9DD4273A}
Description: Cannot create an instance of the XML Document Object Model. MSXML may not be registered.
End Error
Could not load package "C:\SSISPackage\Export.dtsx" because of error 0x80040154.
Description: Cannot create an instance of the XML Document Object Model. MSXML may not be registered.
Source: {4A25AD3F-9118-40FE-9A9B-0CEF9DD4273A}
Started: 5:27:47 PM
Finished: 5:27:48 PM
Elapsed: 0.313 seconds
Report

Replies, comments and Discussions:

  • 工作学习 / 学科技术讨论 / SOS: How to update an existing SQL Server SSIS package saved in File System? Will it work if overwrite the old package in the Server with a new version dtsx file? Thanks!
    • Just simply deploy the packages to the same folder where the old ssis packages in, the old packages will be overided automatically. btw, you have to have the right permission on that folder.
      • Simply copy over the new dtsx file to replace the old one won't work ?
        • It maybe work when not using configuration (via dtsexec). But deployment is suggested, since it will register the packages in sql where you can use configuration and security etc. 在这讨论这个问题?!到微软论坛来吧。
          • here is the error message when I run the new dtsx that was copied over
            Message
            Microsoft (R) SQL Server Execute Package Utility
            Version 9.00.4035.00 for 32-bit
            Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

            Started: 5:27:47 PM
            Error: 2011-08-05 17:27:48.11
            Code: 0xC0011009
            Source: {4A25AD3F-9118-40FE-9A9B-0CEF9DD4273A}
            Description: Cannot create an instance of the XML Document Object Model. MSXML may not be registered.
            End Error
            Could not load package "C:\SSISPackage\Export.dtsx" because of error 0x80040154.
            Description: Cannot create an instance of the XML Document Object Model. MSXML may not be registered.
            Source: {4A25AD3F-9118-40FE-9A9B-0CEF9DD4273A}
            Started: 5:27:47 PM
            Finished: 5:27:48 PM
            Elapsed: 0.313 seconds