Error inserting into column type numeric(19,0)null

[jackson33]

I keep receiving the error below when trying to generate data for a column of type numeric(19,0)null...

[dbo].[SqlDataGeneratorTest]
The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified
target column.
System.InvalidOperationException: The given value of type SqlDecimal from the data source cannot be converted
to type decimal of the specified target column. ---> System.InvalidOperationException: The given value of type
SqlDecimal from the data source cannot be converted to type decimal of the specified target column. --->
System.ArgumentException: Parameter value '2' is out of range. --- End of inner exception stack trace --- at
System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata) --- End of inner
exception stack trace --- at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData
metadata) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() at
System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount) at
System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader) at az.a(CancellableController , Int32 ,
Int32 , ConnectionProperties , GenerateAction , SqlConnection , SDGProject , GenerationReport )

It would appear that 1 is a valid entry but 2 is not. Distribution is set to Sequential. Set unique is checked. Min is set at 1, max at 9,999,999,999,999,999,999.
Any help is greatly appreciated.
Tim

[Brian Donahue]

Hi Tim,

Sorry, this does seem to be a bug in Data Generator. The reference number with our development team is SDG-857, and it is being reviewed. There is no known workaround at this time, short of changing the column datatype to an integer.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[jackson33]

Thanks for looking into Brian. Unfortunately I don't control the data type of that column. If I figure out any work arounds I'll post them up.

[paulj]

has this issue been resolved? how can I work around this without having to change the type to an integer?

[paulj]

i figured out a work around. I had to write my own random decimal UDF and then use it in a sql statement for the random generated value for the specific columns that are of type decimal.

talk about a pain in the butt. the tool isn't very useful if it's going to bomb on any decimal datatype column....