1.open the"tool"-->"wizard",select "data transfermation services",seclect DTS
export wizard2.in "choose a data source" window,select the database which contain ur tables
(remember to choose OLE DB provider for SQL sever)3.at the next step,remember to choose the dastination of "TEXT FILE" and fill in
ur text filename.4.the important step. don't forget to select the choise of "use a query to ..."5. in the "type sql statement"window,click the "query builder"botton.6. now choose the table u want,and u can modify the column!
wish u good luck.
export wizard2.in "choose a data source" window,select the database which contain ur tables
(remember to choose OLE DB provider for SQL sever)3.at the next step,remember to choose the dastination of "TEXT FILE" and fill in
ur text filename.4.the important step. don't forget to select the choise of "use a query to ..."5. in the "type sql statement"window,click the "query builder"botton.6. now choose the table u want,and u can modify the column!
wish u good luck.
你可以试试用DTS Designer.