Home Forums Programming CLR Integration and Programming. SQL View as XML then create output file RE: SQL View as XML then create output file

  • March 31, 2015 at 7:34 am

    #1787711

    SteveEClarke (3/31/2015)

    Apologies -

    Command line;

    Create format file;

    bcp [SysproCompanyS].[dbo].[View_SLG_FinanceForecast_StockCodes] format nul -n -f C:\XMLExport\StockCodeFormat.xml -x -T

    Create data file;

    bcp [SysproCompanyS].[dbo].[View_SLG_FinanceForecast_StockCodes] out c:\xmlexport\StockCodes.xml -f C:\XMLExport\StockCodeFormat.xml -T -c

    Try with character type format:

    bcp [SysproCompanyS].[dbo].[View_SLG_FinanceForecast_StockCodes] out c:\xmlexport\StockCodes.xml -f C:\XMLExport\StockCodeFormat.xml -T -c

    -- Gianluca Sartori