analyse before import

[ruupy]

Hellow 2 u all,
As a novice on SQL i'd like to ask for advice on the following. I need to analyse a txt-file (line-by-line and character-by-character) before i enter the data in a database. I need the possibility to skip a line or even skip a character.

DTS is a great option but the control over what to import and what not is too small.
Creating a DLL in delphi and using that inside an XP (extended procedure) is an option but i'd like to know if it's possible to use plain and simple SQL code to create a SP without the use of external DLL's or DTS.

Any help is greatly appriciated!!!

Thanks
&
Regards

RuupY

 

[foxdev]

Ruupy, what we do for some files that come from external clients (and over whom we have no control) is to create staging tables that look and smell like the production table. Once the data is imported into the staging table, we have TSQL scripts within DTS that do some evaluations and can selectively insert them into the production table.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org