Экспорт таблицы SQL server в файл CSV/XLS
We want to export SQL server table data into csv file to import into Redshift but for some of the columns export into csv is failing due to muli-lines, specail characters, comma in line and it's not creating proper csv file.Following is one of the column in my table, how i can add everything in single cell in cvs for such columns?
"**Challenges** For medical device manufacturers, unplanned equipment downtime negatively impacts patient outcomes. That's why medical device manufacturers are adopting a remote service approach. **Solution** A Medical device manufacturer used thugs to easily connect to medical devices in the field for remote monitoring of status and performance. The *thugs Edge Microserver* provides secure, bi-directional connection to send data that is displayed on the web application created using *thugs Mashup Builder*. Different machine types are modeled using purpose built features of *thugs Composer* that anticipate this exact use case. thugs seamlessly integrates with other enterprise systems to create a comprehensive, enterprise-wide solution and provides flexibility to meet the necessary security and auditing requirements. **Results** Service employees detect, diagnose, and resolve problems faster, minimizing or even preventing equipment downtime. They can also more effectively collaborate with field service technicians to provide contextual guidance, improving first-time fix rates. Data collected from connected devices is easily integrated into other existing business processes—such as parts planning and allocation or compliance reporting—which further enhances outcomes and reduces costs. Many manufacturers are also leveraging data to develop and deliver differentiated, value-add services, like automatic consumables replenishment and usage-based billing. ![inds](//cht-abcd.s3.amazonaws.com/dsc/led/land%20Ps/inds.png)"
Что я уже пробовал:
sqlcmd -S servername -E -Q "set nocount on; set ansi_warnings off; SELECT id,'""' + cast ([description] as nvarchar(max)) + '""' As description FROM [dbname].[schemanem].[tablename]" /o tags.tmp /s "," -W