Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    7

    Unanswered: bcp out sybase and bcp into MS sql server

    I need to bcp out from a sybase table but only need a subset of the columns, not all the columns and then bcp them into a MS sql server table. Does a format file work in this case? If so, how do you creat this format file?

    Also, if I bcp out the entire table from Sybase without skipping columns, is there anything I can do on the SQL server end to eliminate some of the sybase columns when I bcp in?

    thanks,

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Easiest way would be to create a view of the columns you want, then BCP out the view.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •