??????????????????SQL Server?е????????????????????????й?????????????????????SSIS??????????????????????????????????????Щ????????????SSIS?????С?????????SQL Server???????????????BUG?????????????????BCP??
????????????XML
??????SQL Server 2005??????????for xml????????????????????XML??????????????????????????????XML?????BCP???????????XML???
??????????????????

??????????????????BCP??????????л???????????XML??????????棺
????BCP "SELECT TOP 30 [bom_no]??[LEVEL] FROM [sqladmin].[dbo].[bom] FOR XML path??TYPE?? ELEMENTS ??ROOT('RegionSales')" QUERYOUT "d: emp est.XML" -c -t -T -S localhost

????????????Test.XML??????????????????????????????????????????????????????????

????????????JSON
????????????SQL Server??????????Json????????????????ó?????????з??????????????SQL Server??????????????????????С???????????汾????????????????????????????http://jaminquimby.com/servers/95-sql/sql-2008/145-code-tsql-convert-query-to-json????????????????????洢??????????????????BCP????

????????????????????????