DSXchange

Hi all,

i have one user defind query like below

delete * from <<table_name>>;

Insert into <<table_name>>
(

--
--
---
)
select * from <<Table_name1>>


The above user defined query i have to place in single stage in Parallel Job like (serevr jobs ODBC stage)

I am trying to place in DRS or Entrprise ODBC ,But i am not able place at a time, Is there any way to palce whole SQL query.

Regards,
Mohan

what is the database.
oracle, you can try for Stored procedure stage.

Hi Keshav ,

My database is SQL Server.

so this query will run only once?

In the past I have issued this kind of call in the 'Open' command string or in the 'Before' sql section.

For the actual data extract part I've included a 'SELECT COUNT(*)' for the table being populated to allow further checks and reporting on the actual number of records inserted.