When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.  Read more...

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.  Read more...

This example shows how to export data in txt file using bcp command From SQL Server 2005  Read more...

Using opendatasource to retrieve data from Excel files as if querying a table.  Read more...

Dynamically generate XML format file for use with OPENROWSET or XML bulk insert.  Read more...

Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.  Read more...

Read more...

It's a scripts about working with Flat Files  Read more...

The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.  Read more...

The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.   Read more...

This example shows how to export data in txt file using bcp command From SQL Server 2005  Read more...

Using opendatasource to retrieve data from Excel files as if querying a table.  Read more...

With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.  Read more...

Bulk copy table data into formatted files.  Read more...

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.  Read more...

The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.  Read more...