BKennedy2008
asked on
SSIS data type mismatch in criteria expression - need help
I have a SSIS with an OLE DB connection Manager pointing to an Excel File. In my OLE DB Source Editor, I have a sql statement that says : Select F1 as 'This', F2 as 'total' where F2 > 0
Column F2 is a Number, but yet when i execute the dtsx package I get
data type mismatch in criteria expression (Microsoft Office Database Engine)
I am using office 12.0 access database engine OLEDB Provider
I tried to (CAST (F12) as int) > 0 but get null
Column F2 is a Number, but yet when i execute the dtsx package I get
data type mismatch in criteria expression (Microsoft Office Database Engine)
I am using office 12.0 access database engine OLEDB Provider
I tried to (CAST (F12) as int) > 0 but get null
is the column F2 formatted as a number if it isnt it will be read as text even though it contains a number
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks I delt with the template in Excel. The Column was formated to a number.
I did have a formula in there, and said if column A was blank to make column 2 blank. Instead I made it = 0 if column 1 is blank, and even though it fills the column with zeros, it works. So I guess I will deal with that. Thanks
I did have a formula in there, and said if column A was blank to make column 2 blank. Instead I made it = 0 if column 1 is blank, and even though it fills the column with zeros, it works. So I guess I will deal with that. Thanks
Thanks for the grade. Good luck with your project. -Jim