升級 Integration ServicesUpgrade Integration Services

適用於: 是SQL Server,包括在 Linux 上 是Azure SQL Database 是Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

如果您的電腦上目前安裝有 SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) 或更新版本,您可以升級到 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS)If SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) or later is currently installed on your computer, you can upgrade to SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS).

如果您在安裝其中一個舊版 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) 的電腦上升級到 Integration ServicesIntegration Services ,則 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) 會與舊版並存安裝。When you upgrade to SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) on a machine that has one of these earlier versions of Integration ServicesIntegration Services installed, SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) is installed side-by-side with the earlier version.

有多個版本的 dtexec 公用程式會隨著這個並行安裝一併安裝。With this side-by-side install, multiple versions of dtexec utility are installed. 為確保您執行正確的公用程式版本,請在命令提示字元中輸入完整路徑 (<磁碟機>:\Program Files\Microsoft SQL Server\<版本>\DTS\Binn) 來執行公用程式。To ensure that you run the correct version of the utility, at the command prompt run the utility by entering the full path (<drive>:\Program Files\Microsoft SQL Server\<version>\DTS\Binn). 如需有關 dtexec 的詳細資訊,請參閱< dtexec Utility>。For more information about dtexec, see dtexec Utility.

注意

在舊版 SQL ServerSQL Server中,當您安裝 SQL ServerSQL Server 時,Users 群組中的所有使用者預設都能存取 Integration ServicesIntegration Services 服務。In previous versions of SQL ServerSQL Server, by default when you installed SQL ServerSQL Server all users in the Users group had access to the Integration ServicesIntegration Services service. 安裝 SQL ServerSQL Server時,使用者則無法存取 Integration ServicesIntegration Services 服務。When you install SQL ServerSQL Server, users do not have access to the Integration ServicesIntegration Services service. 因此,服務預設是安全的。The service is secure by default. 安裝 SQL ServerSQL Server 之後, SQL ServerSQL Server 系統管理員必須執行 DCOM 組態工具 (Dcomcnfg.exe),授與特定使用者 Integration ServicesIntegration Services 服務的存取權限。After SQL ServerSQL Server is installed, the SQL ServerSQL Server administrator must run the DCOM Configuration tool (Dcomcnfg.exe) to grant specific users access to the Integration ServicesIntegration Services service. 如需詳細資訊,請參閱 Integration Services Service (SSIS Service) (Integration Services 服務 (SSIS 服務))。For more information, see Integration Services Service (SSIS Service).

在升級 Integration Services 之前Before Upgrading Integration Services

我們建議您在升級到 SQL ServerSQL Server之前,最好先執行 Upgrade Advisor。We recommended that you run Upgrade Advisor before you upgrade to SQL ServerSQL Server. Upgrade Advisor 會報告當您將現有的 Integration ServicesIntegration Services 封裝移轉至 SQL ServerSQL Server 所使用的新封裝格式時可能會遇到的問題。Upgrade Advisor reports issues that you might encounter if you migrate existing Integration ServicesIntegration Services packages to the new package format that SQL ServerSQL Server uses.

注意

在 SQL Server 2012 中,已停用為移轉或執行 Data Transformation Services (DTS) 套件所提供的支援。Support for migrating or running Data Transformation Services (DTS) packages has been discontinued in SQL Server 2012. 下列 DTS 功能已停用:The following DTS functionality has been discontinued.

  • DTS 執行階段DTS runtime
  • DTS APIDTS API
  • 可將 DTS 封裝移轉到下一版 Integration ServicesIntegration ServicesPackage Migration Wizard for migrating DTS packages to the next version of Integration ServicesIntegration Services
  • DTS 封裝維護的支援 SQL Server Management StudioSQL Server Management StudioSupport for DTS package maintenance in SQL Server Management StudioSQL Server Management Studio
  • 執行 DTS 2000 封裝工作Execute DTS 2000 Package task
  • DTS 封包的 Upgrade Advisor 掃描。Upgrade Advisor scan of DTS packages.

如需其他已停止功能的相關資訊,請參閱 SQL Server 2016 中已停止的 Integration Services 功能For information about other discontinued features, see Discontinued Integration Services Functionality in SQL Server 2016.

升級 Integration ServicesUpgrading Integration Services

您可以使用以下其中一個方法來升級:You can upgrade by using one of the following methods:

  • 執行 SQL ServerSQL Server 安裝程式,並選取從 SQL Server 2008、SQL Server 2008 R2、SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2014 (12.x)SQL Server 2014 (12.x) 升級的選項。Run SQL ServerSQL Server Setup and select the option to Upgrade from SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), or SQL Server 2014 (12.x)SQL Server 2014 (12.x).

  • 在命令提示字元上執行 setup.exe,並指定 /ACTION=upgrade 選項。Run setup.exe at the command prompt and specify the /ACTION=upgrade option. 如需詳細資訊,請參閱從命令提示字元安裝 SQL Server 2016 中的<Integration ServicesIntegration Services 的安裝指令碼>一節。For more information, see the section, "Installation Scripts for Integration ServicesIntegration Services," in Install SQL Server 2016 from the Command Prompt.

您無法使用升級作業來執行下列動作:You cannot use upgrade to perform the following actions:

  • 重新設定現有的 Integration ServicesIntegration Services安裝。Reconfigure an existing installation of Integration ServicesIntegration Services.

  • 從 32 位元移到 64 位元版本的 SQL ServerSQL Server 或是從 64 位元版本移到 32 位元版本。Move from a 32-bit to a 64-bit version of SQL ServerSQL Server or from a 64-bit version to a 32-bit version.

  • 將某個當地語系化的 SQL ServerSQL Server 版本移到另一個當地語系化的版本。Move from one localized version of SQL ServerSQL Server to another localized version.

當您升級時,可以同時升級 Integration ServicesIntegration ServicesDatabase EngineDatabase Engine,或是只升級 Database EngineDatabase EngineIntegration ServicesIntegration ServicesWhen you upgrade, you can upgrade both Integration ServicesIntegration Services and the Database EngineDatabase Engine, or just upgrade the Database EngineDatabase Engine, or just upgrade Integration ServicesIntegration Services. 如果只升級 Database EngineDatabase Engine,雖然 SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) 或更新版本仍可運作,但是沒有 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS)的功能。If you upgrade only the Database EngineDatabase Engine, SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) or later remains functional, but you do not have the functionality of SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS). 如果您只升級 Integration ServicesIntegration Services,雖然 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) 可完整運作,但是除非另一部電腦提供了 SQL Server 2019 資料庫引擎SQL Server 2019 Database Engine 的執行個體,否則就只能將封裝儲存在檔案系統中。If you upgrade only Integration ServicesIntegration Services, SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) is fully functional, but can only store packages in the file system, unless an instance of the SQL Server 2019 資料庫引擎SQL Server 2019 Database Engine is available on another computer.

將 Integration Services 和 Database Engine 都升級到 SQL ServerSQL ServerUpgrading Both Integration Services and the Database Engine to SQL ServerSQL Server

本章節描述執行具有以下準則之升級的作用:This section describes the effects of performing an upgrade that has the following criteria:

  • 您同時將 Integration ServicesIntegration ServicesDatabase EngineDatabase Engine 的執行個體升級到 SQL ServerSQL ServerYou upgrade both Integration ServicesIntegration Services and an instance of the Database EngineDatabase Engine to SQL ServerSQL Server.

  • Integration ServicesIntegration ServicesDatabase EngineDatabase Engine 的執行個體位於相同的電腦上。Both Integration ServicesIntegration Services and the instance of the Database EngineDatabase Engine are on the same computer.

升級程序執行的工作What the Upgrade Process Does

升級程序會執行以下工作:The upgrade process does the following tasks:

  • 安裝 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) 檔案、服務和工具 (Management StudioManagement StudioSQL Server Data ToolsSQL Server Data Tools)。Installs the SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) files, service, and tools (Management StudioManagement Studio and SQL Server Data ToolsSQL Server Data Tools). 如果同一部電腦上有多個 SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的執行個體,在您第一次將任何執行個體升級至 SQL ServerSQL Server時,會安裝 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) 檔案、服務和工具。When there are multiple instances of SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), or SQL Server 2014 (12.x)SQL Server 2014 (12.x) on the same computer, the first time you upgrade any of the instances to SQL ServerSQL Server, the SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) files, service, and tools are installed.

  • SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2014 (12.x)SQL Server 2014 (12.x)Database EngineDatabase Engine 的執行個體升級到 SQL ServerSQL Server 版本。Upgrades the instance of the SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), or SQL Server 2014 (12.x)SQL Server 2014 (12.x)Database EngineDatabase Engine to the SQL ServerSQL Server version.

  • 將資料從 SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) 或更新的系統資料表移到 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) 系統資料表,如下所示:Moves data from the SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) or later system tables to the SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) system tables, as follows:

    • 將封裝從 msdb.dbo.sysdtspackages90 系統資料表移到 msdb.dbo.sysssispackages 系統資料表,而不變更封裝。Moves packages without change from the msdb.dbo.sysdtspackages90 system table to the msdb.dbo.sysssispackages system table.

      注意

      雖然資料會移到不同的系統資料表,但是升級程序並不會將封裝移轉至新的格式。Although the data moves to a different system table, the upgrade process does not migrate packages to the new format.

    • 將資料夾中繼資料從 msdb.sysdtsfolders90 系統資料表移到 msdb.sysssisfolders 系統資料表。Moves folder metadata from the msdb.sysdtsfolders90 system table to the msdb.sysssisfolders system table.

    • 將記錄資料從 msdb.sysdtslog90 系統資料表移到 msdb.sysssislog 系統資料表。Moves log data from the msdb.sysdtslog90 system table to the msdb.sysssislog system table.

  • 將資料移到新的 msdb.sysssis* 資料表之後,移除 msdb.sysdts*90 系統資料表以及用於存取這些資料表的預存程序。Removes the msdb.sysdts*90 system tables and the stored procedures that are used to access them after moving the data to the new msdb.sysssis* tables. 不過,升級會將 sysdtslog90 資料表取代成也名為 sysdtslog90 的檢視表。However, upgrade replaces the sysdtslog90 table with a view that is also named sysdtslog90. 這個新的 sysdtslog90 檢視表會公開新的 msdb.sysssislog 系統資料表。This new sysdtslog90 view exposes the new msdb.sysssislog system table. 這樣可確保以記錄資料表為基礎的報表會繼續執行而不中斷。This ensures that reports based on the log table continue to run without interruption.

  • 為了控制封裝的存取權,建立三個新的固定資料庫層級角色:db_ssisadmin、db_ssisltduser 和 db_ssisoperator。To control access to packages, creates three new fixed database-level roles: db_ssisadmin, db_ssisltduser, and db_ssisoperator. 雖然不會移除 db_dtsadmin、db_dtsltduser 和 db_dtsoperator 的 SQL Server 2005 (9.x)SQL Server 2005 (9.x)Integration ServicesIntegration Services 角色,但是它們會成為對應新角色的成員。The SQL Server 2005 (9.x)SQL Server 2005 (9.x)Integration ServicesIntegration Services roles of db_dtsadmin, db_dtsltduser, and db_dtsoperator are not removed, but are made members of the corresponding new roles.

  • 如果 SSISSSIS 封裝存放區 (也就是 Integration ServicesIntegration Services 服務所管理的檔案系統位置) 是 \SQL Server\90\SQL Server\100\SQL Server\110\SQL Server\120 下的預設位置,請將這些封裝移到 \SQL Server\130下的新預設位置。If the SSISSSIS package store (that is, the file system location managed by the Integration ServicesIntegration Services service) is the default location under \SQL Server\90, \SQL Server\100, \SQL Server\110, or \SQL Server\120 moves those packages to the new default location under \SQL Server\130.

  • Integration ServicesIntegration Services 服務組態檔更新為指向升級的 Database EngineDatabase Engine執行個體。Updates the Integration ServicesIntegration Services service configuration file to point to the upgraded instance of the Database EngineDatabase Engine.

升級程序不會執行的工作What the Upgrade Process Does Not Do

升級程序不會執行以下工作:The upgrade process does not do the following tasks:

  • 不會 移除 SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) 或更新的服務。Does not remove the SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) or later service.

  • 不會將現有的 Integration ServicesIntegration Services 封裝移轉至 SQL ServerSQL Server 所使用的新封裝格式。Does not migrate existing Integration ServicesIntegration Services packages to the new package format that SQL ServerSQL Server uses. 如需如何移轉封裝的相關資訊,請參閱 升級 Integration Services 封裝For information about how to migrate packages, see Upgrade Integration Services Packages.

  • 不會移動已經加入至服務組態檔之檔案系統位置 (預設位置除外) 中的封裝。Does not move packages from file system locations, other than the default location, that have been added to the service configuration file. 如果您先前已經編輯了系統組態檔以加入其他檔案系統資料夾,儲存在這些資料夾中的封裝將不會移至新的位置。If you have previously edited the service configuration file to add more file system folders, packages that are stored in those folders will not be moved to a new location.

  • 在直接呼叫 SQL ServerSQL Server dtexec 公用程式 (dtexec.exe) 的 代理程式作業步驟中,不會更新 dtexec 公用程式的檔案系統路徑。In SQL ServerSQL Server Agent job steps that call the dtexec utility (dtexec.exe) directly, does not update the file system path for the dtexec utility. 您必須手動編輯這些作業步驟來更新檔案系統路徑,以便指定 SQL ServerSQL Server dtexec 公用程式的 位置。You have to edit these job steps manually to update the file system path to specify the SQL ServerSQL Server location for the dtexec utility.

升級之後可以執行的工作What You Can Do After Upgrading

當升級程序完成之後,您可以執行以下工作:After the upgrade process finishes, you can do the following tasks:

  • 執行可執行封裝的 SQL ServerSQL Server Agent 作業。Run SQL ServerSQL Server Agent jobs that run packages.

  • 使用 Management StudioManagement Studio 來管理儲存於 Integration ServicesIntegration ServicesSQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012 (11.x)SQL Server 2012 (11.x)執行個體中的 SQL Server 2014 (12.x)SQL Server 2014 (12.x)封裝。Use Management StudioManagement Studio to manage Integration ServicesIntegration Services packages that are stored in an instance of SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), or SQL Server 2014 (12.x)SQL Server 2014 (12.x). 您必須修改服務設定檔,才可將 SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2014 (12.x)SQL Server 2014 (12.x) 執行個體加入此服務所管理的位置清單。You need to modify the service configuration file to add the instance of SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), or SQL Server 2014 (12.x)SQL Server 2014 (12.x) to the list of locations managed by the service.

    注意

    舊版 Management StudioManagement Studio 無法連接到 SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) 服務。Early versions of Management StudioManagement Studio cannot connect to SQL Server 2017 Integration Services (SSIS)SQL Server 2017 Integration Services (SSIS) Service.

  • 檢查 packageformat 資料行中的值,以識別 msdb.dbo.sysssispackages 系統資料表中的封裝版本。Identify the version of packages in the msdb.dbo.sysssispackages system table by checking the value in the packageformat column. 此資料表有一個 packageformat 資料行可識別每一個封裝的版本。The table has a packageformat column that identifies the version of each package. 值為 3 表示 SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) 封裝。A value of 3 indicates a SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) package. 在您將封裝移轉至新的封裝格式之前,packageformat 資料行中的值都不會變更。Until you migrate packages to the new package format, the value in the packageformat column does not change.

  • 您無法使用 SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2014 (12.x)SQL Server 2014 (12.x) 工具設計、執行或管理 Integration ServicesIntegration Services 封裝。You cannot use the SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), or SQL Server 2014 (12.x)SQL Server 2014 (12.x) tools to design, run, or manage Integration ServicesIntegration Services packages. SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2014 (12.x)SQL Server 2014 (12.x) 工具包含各自對應的 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT)版本、 SQL ServerSQL Server 匯入和匯出精靈,以及封裝執行公用程式 (dtexecui.exe)。The SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), or SQL Server 2014 (12.x)SQL Server 2014 (12.x) tools include the respective versions of SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT), the SQL ServerSQL Server Import and Export Wizard, and the Package Execution Utility (dtexecui.exe). 升級程序並不會移除 SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2014 (12.x)SQL Server 2014 (12.x)工具。The upgrade process does not remove the SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), or SQL Server 2014 (12.x)SQL Server 2014 (12.x)tools. 不過,您無法在已經升級的伺服器上使用這些工具來繼續使用 SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) 或更新的封裝。However, you will not able to use these tools to continue to work with SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) or later packages on a server that has been upgraded.

  • 依預設,在升級安裝中, Integration ServicesIntegration Services 會設定為將與封裝執行相關的事件記錄至應用程式事件記錄檔。By default, in an upgrade installation, Integration ServicesIntegration Services is configured to log events that are related to the running of packages to the Application event log. 當您使用 SQL ServerSQL Server的資料收集器功能時,這個設定可能會產生過多的事件記錄項目。This setting might generate too many event log entries when you use the Data Collector feature of SQL ServerSQL Server. 記錄的事件包括 EventID 12288 "封裝已啟動" 和 EventID 12289 "封裝已成功完成"。The events that are logged include EventID 12288, "Package started," and EventID 12289, "Package finished successfully." 若要停止將這兩個事件記錄到應用程式事件記錄檔,請開啟登錄進行編輯。To stop logging these two events to the Application event log, open the registry for editing. 在登錄中找出 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\SSIS 節點,然後將 LogPackageExecutionToEventLog setting 設定的 DWORD 值從 1 變更為 0。Then in the registry, locate the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\SSIS node, and change the DWORD value of the LogPackageExecutionToEventLog setting from 1 to 0.

只將 Database Engine 升級到 SQL ServerSQL ServerUpgrading only the Database Engine to SQL ServerSQL Server

本章節描述執行具有以下準則之升級的作用:This section describes the effects of performing an upgrade that has the following criteria:

  • 您只要升級 Database EngineDatabase Engine的執行個體。You upgrade only an instance of the Database EngineDatabase Engine. 也就是說, Database EngineDatabase Engine 的執行個體現在是 SQL ServerSQL Server的執行個體,但是 Integration ServicesIntegration Services 的執行個體和用戶端工具是來自 SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2014 (12.x)SQL Server 2014 (12.x)That is, the instance of the Database EngineDatabase Engine is now an instance of SQL ServerSQL Server, but the instance of Integration ServicesIntegration Services and the client tools are from SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), or SQL Server 2014 (12.x)SQL Server 2014 (12.x).

  • Database EngineDatabase Engine 的執行個體位於某部電腦上,而 Integration ServicesIntegration Services 和用戶端工具則位於另一部電腦上。The instance of the Database EngineDatabase Engine is on one computer, and Integration ServicesIntegration Services and the client tools are on another computer.

升級之後可以執行的工作What You Can Do After Upgrading

將封裝儲存於已升級之 Database EngineDatabase Engine 執行個體中的系統資料表,與 SQL Server 2008SQL Server 2008中所用的系統資料表不同。The system tables that store packages in the upgraded instance of the Database EngineDatabase Engine are not the same as those used in SQL Server 2008SQL Server 2008. 因此, SQL Server 2008SQL Server 2008 版的 Management StudioManagement StudioSQL Server Data ToolsSQL Server Data Tools 無法在已升級之 Database EngineDatabase Engine執行個體上的系統資料表內找到封裝。Therefore, the SQL Server 2008SQL Server 2008 versions of Management StudioManagement Studio and SQL Server Data ToolsSQL Server Data Tools cannot discover the packages in the system tables on the upgraded instance of the Database EngineDatabase Engine. 由於找不到這些封裝,所以可以對這些封裝處理的動作也會受到限制:Because these packages cannot be discovered, there are limitations on what you can do with those packages:

  • 您無法使用其他電腦上的 SQL Server 2008SQL Server 2008 工具 ( Management StudioManagement StudioSQL Server Data ToolsSQL Server Data Tools),從已升級的 Database EngineDatabase Engine執行個體載入或管理封裝。You cannot use the SQL Server 2008SQL Server 2008 tools, Management StudioManagement Studio and SQL Server Data ToolsSQL Server Data Tools, on other computers to load or manage packages from the upgraded instance of the Database EngineDatabase Engine.

    注意

    雖然已升級之 Database EngineDatabase Engine 執行個體中的封裝尚未移轉成新的封裝格式,但是 SQL Server 2008SQL Server 2008 工具還是無法找到這些封裝。Although the packages in the upgraded instance of the Database EngineDatabase Engine have not yet been migrated to the new package format, they are not discoverable by the SQL Server 2008SQL Server 2008 tools. 因此, SQL Server 2008SQL Server 2008 工具無法使用這些封裝。Therefore, the packages cannot be used by the SQL Server 2008SQL Server 2008 tools.

  • 您無法使用其他電腦上的 SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) 來執行已升級之 Database EngineDatabase Engine執行個體上的 msdb 內所儲存的封裝。You cannot use SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) on other computers to run packages that are stored in msdb on the upgraded instance of the Database EngineDatabase Engine.

  • 您無法使用 SQL ServerSQL Server 電腦上的 SQL Server 2008SQL Server 2008 代理程式作業來執行已升級之 SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) 執行個體中所儲存的 Database EngineDatabase Engine封裝。You cannot use SQL ServerSQL Server Agent jobs on SQL Server 2008SQL Server 2008 computers to run SQL Server 2008 Integration Services (SSIS)SQL Server 2008 Integration Services (SSIS) packages that are stored in the upgraded instance of the Database EngineDatabase Engine.

外部資源External Resources

blogs.msdn.com 上的部落格文章: 在 Denali 中製作現有的自訂 SSIS 延伸模組和應用程式工作Blog entry, Making your Existing Custom SSIS Extensions and Applications Work in Denali, on blogs.msdn.com.