sequel command from variable

"select * from TABLE01 where COLUMN01 = 060 and ([Copy of DATE_TRANSFER] > '2006 - 09 - 12')"

this sql command worked for "sequel command from variable" in the OLE DB source editor

data data type

[OLE DB Destination [498]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].TAV Factors'. ".

DT_DBTIMESTAMP needs to be converted to DT_DATE . DT_DATE is in the real format while the other is more like a structure and gives an error.

Data Mining Query

Data Mining Query gave an error because of data type.
I wasnt using the data columns (variables) for which it was showing the error.
I created a new table where the data type for columns (variable) was changed from Numeric (a,b) was changed to type "real". This table had no column (variable) with data type Numeric and when used this table the project went through without any errors.

Surviving SSIS, one more day one more error resolved.

SSIS data mining model training

data mining model training apparently doesnt accept DT_NUMERIC data type which is accepted in the Analysis Services. We might need to change it to another data type.