The provider could not determine the Double value error on data source import query

Article:TECH127565  |  Created: 2010-05-17  |  Updated: 2010-05-17  |  Article URL http://www.symantec.com/docs/TECH127565
Article Type
Technical Solution


Issue



The error "The provider could not determine the Double value. For example the row was just created, the default for the Double column was not available, and the consumer had not set a new Double value." is thrown when you test some SQL for an import query when adding a data source.

Solution



The issue was trying to append different datatypes together. The must be explicitly cast to, for instance, the string datatype for this to work.

For instance:
select [Region Desc]+'-'+[Country Code]+'-'+'Order#: '+[Purchase Order Num] as [Lease Agreement],* from [Report$]

Should be:

select [Region Desc]+'-'+[Country Code]+'-'+'Order#: '+STR([Purchase Order Num]) as [Lease Agreement],* from [Report$]


Legacy ID



52915


Article URL http://www.symantec.com/docs/TECH127565


Terms of use for this information are found in Legal Notices