將檔案系統上 DTS COM file 批次載入到 SQL 2000

透過升級精靈升級 DTS 時,若 DTS 放在 SQL Server,可以一次複選全部升級,但若是放在檔案上,則一次只能選一個檔。

可以透過如下的 Script 將 DTS 封裝都放到 SQL Server 再升級

ImportDTSPackagesToSQL2000.vbs

Script 取自 http://itknowledgeexchange.techtarget.com/itanswers/import-sql-2000-dts-package-to-new-box/

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: