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

Save Up to 91% on Cloud Compute With Spot VMs

Automatic sustained-use discounts. One free VM per month. No negotiation needed.

Run batch jobs at 60-91% off with Spot VMs. Long-running workloads get automatic discounts with sustained use.

Try Free

Rate This Project

User Reviews

Be the first to post a review of ExportTxt2msSQL!

Additional Project Details

Operating Systems

Windows, Windows Server

Intended Audience

Developers, System Administrators

User Interface

Command-line, Win32 (MS Windows)

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

DbVisualizer

DbVisualizer is a universal database client for anyone who works with data, from solo developers and startups to professional teams managing complex environments, including developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It offers a graphical interface...

See Software
Google Cloud SQL

Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade. Reduce maintenance costs with...

See Software
Windocks

Windocks is a leader in cloud native database DevOps, recognized by Gartner as a Cool Vendor, and as an innovator by Bloor research in Test Data Management. Novartis, DriveTime, American Family Insurance, and other enterprises rely on Windocks for on-demand database environments for development,...

See Software
Foxit Document Workflow APIs

Foxit provides a powerful suite of cloud-native APIs that help organizations automate, secure, and modernize document workflows. Built on scalable REST architecture, Foxit APIs enable developers to generate, convert, extract, sign, and display documents directly within applications—eliminating...

See Software
Eurekos

Eurekos is the customer training LMS built to educate the world outside your organization – partners, distributors and resellers. Most companies spend years perfecting their product, then hand customers a repurposed employee training course and hope for the best. When those customers churn,...

See Software
SurveyJS

SurveyJS is an embeddable, self-hosted, white-label form builder for teams building custom forms, surveys, questionnaires, and other data collection tools inside web applications. It runs entirely on the client and is fully compatible with all modern JavaScript frameworks, including React,...

See Software