SQL Server DBA, BI Analyst and Microsoft MVP

Categories

File Manipulation

13 posts

SQL Server - How to compress and decompress files and directories using 7-zip and xp_cmdshell or SQLCLR (C#)

June 10, 2018 9 min read

Continue reading

SQL Server - File Operations Using xp_cmdshell: How to List, Read, Write, Copy, Delete and Move Files

August 29, 2017 6 min read

Continue reading

SQL Server - How to export and import tabular data files (for example, CSV) using CLR (C#)

March 20, 2017 8 min read

Continue reading

SQL Server - How to integrate with FTP and list, upload, and download files using CLR (C#)

November 6, 2016 18 min read

Continue reading

SQL Server - How to run PowerShell and Prompt-DOS (MS-DOS) scripts using CLR (C#)

September 11, 2016 6 min read

Continue reading

SQL Server - How to export the source code of all Stored Procedures, Functions, Views and Triggers from a database to .sql files

August 25, 2016 6 min read

Continue reading

SQL Server - How to read, import and export data from XML files

June 18, 2016 27 min read

Continue reading

SQL Server - Importing and Exporting Data from Excel Spreadsheets

June 15, 2016 5 min read

Continue reading

SQL Server - How to export database data to a text file (CLR, OLE, BCP)

June 3, 2016 16 min read

Continue reading

SQL Server - How to import text files into the database (OLE Automation, CLR, BCP, BULK INSERT, OPENROWSET)

May 29, 2016 7 min read

Continue reading

SQL Server - How to list, read, write, copy, delete and move files with CLR (C#)

May 7, 2016 11 min read

Continue reading

Importing CSV files into SQL Server database

June 14, 2014 4 min read

Continue reading

File operations using OLE Automation in SQL Server

June 14, 2014 10 min read

Continue reading