ExportTxt2msSQL

Uses the Microsoft DTS (Data Transformation Services) Engine to export each line a text file (or a set of text files) as a row in a table in a Microsoft SQL Server (2000/2005) database.
Can filter for a folder, list of folders, exclusion list for files, selected file extensions.
Configuration kept in an XML file.

Features

Export lines in a text file to Microsoft SQL Server.
Choose file/folder/subfolders, with exclusion list and file extension types list to process
Useful for code lines analysis for any notepad-readable code files such as FRM, BAS, CLS, VBP and also TXT files.
Unattended run configurable with parameters in a config XML file.

Project Samples

Project Activity

See All Activity >

License

Creative Commons Attribution License

Follow ExportTxt2msSQL

ExportTxt2msSQL Web Site

Other Useful Business Software

Enterprise-grade ITSM, for every business

Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity.

Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.

Try it Free

Rate This Project

User Reviews

Be the first to post a review of ExportTxt2msSQL!

Additional Project Details

Operating Systems

Windows Server, Windows

Intended Audience

System Administrators, Developers

User Interface

Win32 (MS Windows), Command-line

Programming Language

Visual Basic

Database Environment

Microsoft SQL Server

Related Categories

Visual Basic Documentation Software, Visual Basic Source Code Analysis Tool, Visual Basic Code Review Software

Registered

2013-07-19

Similar Business Software

WildEdit

If you ever need to make the same changes to many files at once, then WildEdit will save you a lot of time. It is an interactive tool for users to edit a set of plain text files in a folder hierarchy, filtered by wildcards. This makes it ideal for editing web pages and software source code or...

See Software
SSIS

SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL...

See Software
XiMpLe

A simple editor for XML and JSON files based on a grid table view with some unique functionalities. User doesn't need to care about xml or json rules. It's possible to compare and merge xml files in a grid view. There is a support for validating xml with XSD schema(s). It can be used also...

See Software