Hi David, you get this error message when you try to convert a ntext  field directly into a integer field. DECLARE @MyTable TABLE ([Description] ntext ) INSERT INTO @MyTable SELECT '123456789' This table has one column 'Description' which has the data type = ntext  and the value '123456789' SELECT CONVERT(INT, [Description] ) from @MyTable  will return exactly that message. If you convert first into VARCHAR and then to int, that will work. SELECT CONVERT(INT, CONVERT(VARCHAR(50),[Description]))  from @MyTable So if you are using a database table as input data for BI, you need to convert this ntext field first into a varchar field. When the content of this column has only digits, then BI will be able to convert this content implicitly into an int and insert into the column which is defined as int. Sumi     ... View more