Skip to Content
0
Former Member
Jan 16, 2008 at 11:41 AM

Regarding Requirement Query

15 Views

hi

this is my requirement

Read a CSV file ( Header, Body, Trailor)

Reading File name is required along with Time Stamp.

Part of file name need to be extracted to make a query

Select Query to table 1 (Synchronous)

Select Query to table 2 (Synchronous)

Select Query to table 3 (Synchronous)

Insert into one table using all previous Select and CSV data.

Collect no of rows updated.

Give me good solution how to solve this