Post reply

BCP command to import values for selected columns

  • August 2, 2011 at 11:40 am

    #255147

    Hello Friends,

    I am trying to implement BCP command for transferring data from one server to another. I know that we would be able to export the values of selected columns using bcp by using the queryout option. Is it possible to import values for selected columns in a table using the bcp command. If so, please let me know the way to do it.

    Your help would be appreciated..

    Thanks,

    Murali

  • August 2, 2011 at 11:49 am

    #1362416

    please have a look at this link.

    The link contains information on how to use a format file with bcp.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • August 2, 2011 at 11:53 am

    #1362424

    Hi Lutz,

    The link is not opening. Can u give the complete link.

    Regards,

    Murali

  • August 2, 2011 at 12:13 pm

    #1362460

    link is fixed (and verified). Sorry.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • August 2, 2011 at 12:26 pm

    #1362481

    Thanks for ur response Lutz.. That was really helpful

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

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