Viewing 15 posts - 16 through 30 (of 44 total)
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...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 26, 2009 at 11:02 am
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?
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 26, 2009 at 10:30 am
Thanks D Smith,
i'll try that and i hope it works for me.
thanks a lot!
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 24, 2009 at 9:47 am
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...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
January 22, 2009 at 4:39 am
you might need to check there isn't any other character in the fields concerned, such as a space. gyessql's solution works perfectly
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
January 22, 2009 at 2:59 am
thanks Andrew, it works perfectly.
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
January 21, 2009 at 5:02 am
i'm using varchar
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
January 21, 2009 at 4:19 am
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!
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
September 22, 2008 at 4:42 am
that's my next point of call, i wanted to make sure i had explored all other options.
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
June 12, 2008 at 3:14 am
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...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
June 11, 2008 at 9:52 am
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...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
June 4, 2008 at 10:05 am
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...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
May 9, 2008 at 10:24 am
Ed,
could you please put me through steps you used to configure database mail. i've been struggling with it.
thanks
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
April 25, 2008 at 5:04 am
thanks Jez,
that worked perfectly.
Cheers
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
April 24, 2008 at 6:47 am
Thanks Micheal,
i got such a fright. i'll investigate the cause of disparity now that i know i didn't cause it.
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
April 18, 2008 at 3:43 am
Viewing 15 posts - 16 through 30 (of 44 total)