關於DTS數據自動導入
Relta 2005-03-25 12:59:22 我現在建了一個數據導入的DTS, 是從AS400/DB2數據中導入一個表的數據到SQL Server 2000的服務器中,為什麼DTS中連接DB2數據庫的Password沒辦法保存呀,我手工執行這個DTS時,是沒有問題,可設置自動運行時,卻會提示錯誤,如下:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: Create Table [PRODA201].[dbo].[IMFEXEA] Step
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005)
Error string: CWBSY0002 - Password for user RPTDEV on server 100.100.100.200 is not correct
Error source: IBMDA400 Session
Help file:
Help context: 0
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 8002 (1F42)
Error string: CWBSY0002 - Password for user RPTDEV on server 100.100.100.200 is not correct
Error source: IBMDA400 Session
Help file:
Help context: 0
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
DTSRun OnFinish: Create Table [PRODA201].[dbo].[IMFEXEA] Step
DTSRun: Package execution complete.