I have a SSIS Data Flow Task which load a XML file into a table. While working with a XML file of 1.2M, I don't have any problem. However, with a XML file of 16 M, I get the following error:
[XML Source ] Error: The value was too large to fit in the output column "MemberRole" (33268).
In the table, this column is bigint and I used eight byte signed integer in the external and internal column properity.
Can somebody help?