i 'm trying to get the data out in a date time format, the source is also a datetime. however, when it gets into the csv file it's formatted as...

thanks D Smith, it worked perfectly!

the other part of my question remains, can anyone help me with how to format the datetime field within the package?

Thanks D Smith,

i'll try that and i hope it works for me.

thanks a lot!

I'm not clear on your explanations either, but from the little i understand your problem is with the second part of your query (statut = 3)

based on that u might...

you might need to check there isn't any other character in the fields concerned, such as a space. gyessql's solution works perfectly

thanks Andrew, it works perfectly.

i'm using varchar

thanks Maine,

i have resolved the problems i was having. sorry for the extremely late acknowledgement.

the notification mail just got to my inbox 3 days ago!

that's my next point of call, i wanted to make sure i had explored all other options.

thanks for your contributions so far

Jim,

that would mean turning off the security policy on both windows and SQL and that isn't what i intend to do. I need to...

They ask a few questions of the manager like, "So do you think the candidate will need ASP.NET experience?"

"Yes, of course."

"Would the candidate need to understand Windows security?"

"It would...

by the log, i assume you mean the maintenance plan report.

here is the content of the report:

NEW COMPONENT OUTPUT

Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3054

Report was generated on "APSSQL".

Maintenance...

Ed,

could you please put me through steps you used to configure database mail. i've been struggling with it.

thanks

thanks Jez,

that worked perfectly.

Cheers

Thanks Micheal,

i got such a fright. i'll investigate the cause of disparity now that i know i didn't cause it.