how to excecute bunch of sql statements

[ann]

Hi all,
I have a file.sql text file with bunch of sql statements. Which are insert statements. How can i excecute this in batch job or in a regular job?
I need to create a job which excecutes this and need to schedule it.

thanks in advance,
ann.

[chulett]

Why not convert the inserted data into a sequential file and then use a 'regular' job to process it? Why the 'need' to do it this way?

[kumar_s]

Or read each line from the file and pass as parameter to a job which inserts into the table or use comand activity to execute comand line insert from the job sequence which inturn can be scheduled.

[kris007]

Can't you execute those insert sql statements from the before or after tab of the Target Stage? Just a thought