ETL and Data Integration tools - Modern ETL software for everyone

Dear Mike,

I have couple of queries

1) I need to run a series of sql statments and how can i encapsulate in one sql script and run once like

insert into gl_flx select * from gbtb_flx where condition statment

delete from gbtb_flx where condition statments

I want to do these 2 sql statment in 1 sql script

2) When i close the Visual Importer window the one schduled job is not working,I need to keep open it .

rgds
jelson

Jelson

1 Create a new script and specify SQL Statements Delimiter.
2 tick use Agent to execute packages and run agent as windows service

Mike