Importing DataTables from BizTalk

Importing DataTables from BizTalk

  
Hi,

I'm trying to import some Tabels from a BizTalk DB.

I connect correctly to the database, I'm able to chosse the tables but when I cllick next, I get this error:

"Error rettrieving entities. Value was either too large or too small for an int16"

What can it be?

Thank's in advance,

Francisco
Hi,

I'm having the same problem, importing tables copied from an OutSystems database.
The problem is when a table has attributes with "text" or "image" data types.

Is there any solution?
Using SQL Server 2005, we find the same error when using "max" in table creation, declaring varchar(max). Please check the link http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1098157,00.html about the max sizes in SQL Server.

Paulo Fernandes e António Braz