I want to inport a eventviewer file saved as *.csv or *.txt into SQL ,and
split one row into muti rows,but I only can use one sign at one time.
I just want to split one row into muti rows with muti signs such as "," and
":",how could I do?

You can reuse the same row in the same transfrm like this

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.
www.konesans.com - Consultancy from the people who know


"Steffen" <yourdisplayname (AT) discussions (DOT) microsoft.com> wrote