naresh0407 (4/5/2014)
Basically i have Header and DetailRow table seperalty.So need to transfer H row to header table and D row to DetailRow.Can i acheve this without scriptask?
I have one table for header which will store the header date,detail table to store the actual data and trailer can be moved to text file or table.I will count the detail records and store the count in variable using rowcounnt tranformation and later i need to match this count with trailer row count ie.4
H,2011-06-02
D,value1,value2,value3,1
D,value1,value2,value3,2
D,value1,value2,value3,3
D,value1,value2,value3,4
T,4, 10
First question, why not use a script task?
There are few options, on a 2005, most would be reading the file line by line and somewhere along the way parse the line into column and insert in a table. The parsing can happen in a script task, derived column task or in the database. Before one can advice on which is the best method, some more details are needed, file sizes, frequency, number of fields/columns and so on.
The easiest and most straight forward way of doing this in SSIS (spell checked :hehe: ), is to load the files straight into a table, one row per line and then use DelimitedSplit8K[/url] to parse it into the destination tables. Or use a script task 😎