Post reply

Remove Step details from SQL Job

  • June 15, 2020 at 1:57 pm

    #3763132

    The reason the columns do not line up is because you have commas in the data.  To avoid this issue you need to set the text qualifier to a double-quote.

    For example - in your actual results (open the file in notepad):

    An County,Bed,5
    An County,Bed or Breakfast,6
    Ann,Cottage,Cabin or Min,45

    What you should have is:

    "An County","Bed","5"
    "An County","Bed or Breakfast","6"
    "Ann,Cottage","Cabin or Min","45"

     

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • June 15, 2020 at 3:20 pm

    #3763180

    Thanks for all the help, I'll try this out.

  • June 15, 2020 at 6:31 pm

    #3763257

    you need to add " (double quote) as the text delimiter on the definition above - once you do that you will be able to open the file correctly in Excel.

    Note that as I said before you do need to use a program that is capable of reading and parsing CSV files correctly.

  • June 15, 2020 at 7:05 pm

    #3763268

    thank you I will try that

Viewing 4 posts - 16 through 18 (of 18 total)

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