Hi
I have csv file which has about 150 records, I need to load this into
a table.

csv file look like this
pen,80,90 1- record
cup,60,100

Ineed to store into a sql sever table like this
pen 80
pen 90 as 2 records
cup 60
cup 100

I thought of using DDQ. I am really stuck... need some help here

Use FSO to parse script.

read a line
array = split(line,","
walk array and insert records
key = array(0)
for n = 1 to ubound( array)
add record
rec.Fields("drawingobject").Value = key
rec.Fields("objectvalue").Value = array(n)
rec.update
next
loop through file until EOS.

It's pseudo code but it will get you started. You can do it as one script
in DTS or as an external script or you can design a DTS scrip that can feed
mutiple line to the output object. This would be harder if you are not good
at scripting and DTS.
--
Jim Vierra

<apanchanathan (AT) gmail (DOT) com> wrote

You may also be able to use this article

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




"Jim Vierra" <jvierra (AT) msn (DOT) com> wrote

It worked....Thanks Allan