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?