SUNNYVALE, USA: Novixys Software, Inc. has released Exult for SQL Server v. 1.1, an easy to use Windows application that helps database administrators to import XML files into a Microsoft SQL ...

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

In this article I am going to write about SQLBulkCopy and its major properties and methods. This article will give you the code for high performance transfer of rows from XML file to SQL server with ...

Create a WCF-Custom one-way send port that picks the XML file from the FILE receive port, constructs the message using the message template, and sends it to SQL Server to execute the stored procedure.

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or ...

The sample project includes all the code in this post, and an interface to upload/download files that may be useful in your projects. The interface of the sample project is shown Figure C.