I need some suggestions on how to go about using DTS to bring a text
file into sql. The catch is that the text file has multiple lines per
record, as defined in the first line of the record. I need to
concatenate the subsequent lines into one field of database.

Example:

record# #lines recordtype

4714007 3 L
line 1
line 2
line 3

4714008 4 L
line 1
line 2
line 3
line 4

Thanks in advance,

Steve Hoyer


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Maybe you can play with the DTSTransformStat values

I do it here though I take 1 input and give multiple outputs

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Steve Hoyer" <stevehoyer (AT) hotmail (DOT) com> wrote

I ended up writing a little vb.net app to deal with it, and just call it
in the DTS package

Thanks

Steve Hoyer


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!