SSIS系列之-BT的OLAP数据库连接字符串导致的问题

最近因为工作的需要，需要通过SSIS从OLAP中导出数据，费了很大的力气，终于把所有的该配的都配对了，但是没想到，一运行就出现下面的错误：

SSIS package "ExtractUserTagPointsFromDataWarehouse.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Error: 0xC0202009 at Data Flow Task, OLE DB Source 1 1 [31]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "OLE DB Source 1 1" (31) failed the pre-execute phase and returned error code 0xC0202009.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination 1" (170)" wrote 0 rows.
Task failed: Data Flow Task
Warning: 0x80019002 at For Loop Container - 按照用户基数循环操作用户: 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.
Warning: 0x80019002 at ExtractUserTagPointsFromDataWarehouse: 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.
SSIS package "ExtractUserTagPointsFromDataWarehouse.dtsx" finished: Failure.

 

注意：
0xC004701A at Data Flow Task, DTS.Pipeline: component "OLE DB Source 1 1" (31) failed the pre-execute phase and returned error code 0xC0202009.

很郁闷，这种问题通常很难寻找到答案，但是我这个人总是比较幸运，呵呵～，从

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=215075&SiteID=1

终于找到了自己的答案

 

In SSIS SP1 the problem can be fixed by adding Format=Tabular to the connection-string. There is a KB on this.

However, after applying SP2 a new error have arised using SSIS to qyery MSAS.

 

原来就是简单的在连接字符串上加个Format=Tabular的问题，这个真的很容易让人头痛！！！！

做数据挖掘和OLAP的人真不容易～唉～

问题解决了！！心情大爽！！一定要把这个问题记下来！！！