Yup mapping is good..datatypes are good..checked the data in data viewer and see data for other columns but not for this column 🙁

Help pls guys..

Any help guys..

Thank you all for the replies..this has helped a lot 🙂

so I think the bottom line is..if I am using datetime data type, to show the values in mm-dd-yyyy I have to convert it into varchar..right?

sorry but not getting..

Thank you for the reply..but you are converting the date type to varchar..I want to keep it datetime

But in the advance editor of the Excel source adapter I have mentioned Unicode String as the data type for this field..so don't think that can be a problem

My bad..the query actually contains a proper WHERE clause..i copied it wrong here

Row 4 is again like below:

CA,93455,9435

I am not able to process the file after row#3 where it is failing in the data flow task..even redirecting the erranous rows fails as...

Thanks for the reply mate..

but I have already mentioned the data type of the columns as Unicode String with 500 length..in the connection manager and in the source adapter as...

I have found the answer..There is an option of FORMAT CODE in the chart properties -> Data -> Values -> Point labels -> Format code..just enter the format there..

e.g. for...

yes..that was oracle code..I have edited it..basic table creation script remains same..so posted here..I dont like oracle

I converted the data to be displayed into integer..that solved my problem:-)

Excellent solution..Thanks a lot mate..I really wholeheartedly appreciate that *clap*

#respect