When running BPMC on SQL Server 2008 and SSIS, the feed fails on Step 1 - Queries with the following error detail in the application event log:
"Failed to obtain column collation information for the destination table. If the table is not in the current database the name must be qualified using the database name (e.g. [mydb]..[mytable](e.g. [mydb]..[mytable]); this also applies to temporary-tables (e.g. #mytable would be specified as tempdb..#mytable)"
This is due to bug in the SQLBulkCopy task of .NET 2.0 when using the character of "." (dot) in your feed name.
See MS tech-net article here:
http://support.microsoft.com/kb/944389
The solution, do not use "." (dots) in your feed names.
Subscribe to:
Post Comments (Atom)
...and the bug is still there: confirmed 28 Mar 2018 in VS 2012 C# for .NET 4.5
ReplyDelete