Re: Text file import strategy - DTS newbie question

#1

Hi Brent,
You need to clean and prepare you file before import to sql.
Inside the pkg you can use ActiveXscript with regular expresions to do it,
here an example.
http://www.4guysfromrolla.com/webtec...ressions.shtml
JFB

"-- Brent --" <bbyrd (AT) online-can (DOT) com> wrote

Quote:

I have an ascii file that has no column delimiters. Fixed-
fields are present but the data is homogeneous over two
lines(separated by CrLf), not one.

Also, the report contains page headers, etc with a CrFF
between each page.

Any DTS strategies would be appreciated.
Currently, I am using a Connection (Text File (Source))
and an ActiveX script within a Transform Data Task.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Text file import strategy - DTS newbie question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Text file import strategy - DTS newbie question - 07-17-2003 , 03:43 PM