[ADO NET Source [2]] Error: The error "Specified cast is not valid." occurred while processing "ADO NET Source.

hi,

i new ms ssis , i'm trying read data table using ado net source (from dwh) , push data mysql server table using odbc destination.

i have mapped columns source target needed - have 7 integer fields , 1 date field.

for date field in ado net source inside sql command using cast :

"cast(getdate() date)  test_date "

the query runs fine when run outside ssis , directly query database,

while running package following error messages :

[ado net source [2]] error: error "specified cast not valid." occurred while processing "ado net source.outputs[ado net source output].columns[test_date]".

[ado net source [2]] error: ssis error code dts_e_inducedtransformfailureonerror.  the "ado net source" failed because error code 0x80004002 occurred, , error row disposition on "ado net source.outputs[ado net source output].columns[test_date]" specifies failure on error. error occurred on specified object of specified component.  there may error messages posted before more information failure.

[ssis.pipeline] error: ssis error code dts_e_primeoutputfailed.  the primeoutput method on ado net source returned error code 0xc02090f5.  the component returned failure code when pipeline engine called primeoutput(). meaning of failure code defined component, error fatal , pipeline stopped executing.  there may error messages posted before more information failure.

thanks in advance on subject.

hi

i have succeded make work 

i didn't use derived coulmn

just ado net source , odbc destination

the problem definition of date type

thanks all.

SQL Server  >  SQL Server Integration Services