Post reply

CVS files out of Sql Server....

  • November 12, 2008 at 12:31 pm

    #126812

    I have been posed a question on "how would you get a cvs file out of Sql Server without using DTS or SSIS?"

    Any answers?? Thank you!!!!

    Thank you!!,

    Angelindiego

  • November 12, 2008 at 12:42 pm

    #897726

    Is this an interview question? hopefully you've answered "I don't know"

    It's easy to do with SSMS as a hint.

  • November 12, 2008 at 12:47 pm

    #897732

    I have this goofy guy that runs a dept next to me that poses questions to STUMP ME! This one did. The answer I gave him was BCP Utility. Not using tools, just straight code...he was happy with the answer!

    Thank you!!,

    Angelindiego

  • November 12, 2008 at 12:59 pm

    #897739

    🙂

    SSMS, get the results, click the upper left corner (or Select All) and then save as. Will output as CSV.

  • November 12, 2008 at 1:10 pm

    #897747

    SWEET!!!!!!!!!!!!!

    Thanks Steve!!

    Thank you!!,

    Angelindiego

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply