[SQL ] 使用SSIS匯入EXCEL失敗

看板Database作者 (阿忠)時間14年前 (2011/10/27 21:57), 編輯推噓1(101)
留言2則, 1人參與, 最新討論串1/1
遇到的警告有兩個 1. [SSIS.Pipeline] Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console. 2.Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. 不知道出了什麼問題? -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 163.25.105.154

11/04 08:37, , 1F
第一個問題, 新增一個伺服器角色讓他擁有所有權限可解決
11/04 08:37, 1F

11/04 08:37, , 2F
第二個感覺是資料庫欄位的問題
11/04 08:37, 2F
文章代碼(AID): #1EgMDD0o (Database)