Hi Hiren,
with bcp you can use format-files to convert data from one table/server to another. In the format file you can either drop cols or specify the new sequence. As a good information about the syntax I can recommend the book "Sybase SQL Server 11 Unleashed" (SAMS Publishing).
Rgds,
Balduri
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.