[Power Map]地圖信賴度的問題

        用city來當作Power Map的地理資訊時，發現有各地圖信賴度，只能辨識出49%的資料，想說怎麼那麼低，報告建議再增加更多的地理欄可提升信賴度，於是又加了country code進去，馬上提升至89%

[SSIS][MySQL Data Provider]Error: The value was too large to fit in the ADO NET Source.

        因為得從MySQL匯入資料到SQL Server上，參考Connecting to MySQL from SSIS此篇，設好ADO NET Source後，測試一下出現如下錯誤

[SSIS]Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.

Warning: 0x80049304 at Data Flow Task, 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.

        印象中以前用BIDS或SSDT沒看過這警示訊息，但用VS 2013設計SSIS專案時就看到這個警示，解法就如訊息中說的右鍵[以系統管理員的身分]執行，就不會出現囉

[SSIS]OLE DB Source連Oracle的錯誤Cannot retrieve the column code page info from the OLE DB provider.

Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

        就在我按下Preview或是Columns時