ETL and Data Integration tools - Modern ETL software for everyone

Hi Mike,

I am working my way through the documentation for ELT Processor.

We have a number of Stored Procedures already written in MS SQL server that we need to process once the data has gone into the table. Is it possible to call a MS SQL stored procedure after the data has been imported into the table?

B

Documentation was updated last evening

>>>>Is it possible to call a MS SQL stored procedure after the data has been imported into the table?

Of course:
Right click on the writer object and select SQL

(Page 107 10.15.8 Running SQL Scripts)

Mike

Please excuse my ignorance via the question below as I am not a programmer (I am just trying to get something to work here which my programmers haven't had time to work on).

The plan with ETL processor pro is to:

1) Get the e-mail attachment
2) use transformation process to insert it into a temporary table on our server
3) Execute the Stored Procedure on SQL server called AccntCalcClearSplitShares_regent

Would I just execute the stored procedure using the SQL script, or, would I have to get all the code from the stored procedure and copy it into the SQL script, in other words, the stored procedure becomes redundant on the server.


Thanks for your help
B

>>>Would I just execute the stored procedure using the SQL script, or, would I have to get all the code from the >>stored procedure and copy it into the SQL script, in otherwords, the stored procecedure becomes redundant on the >>server.

There is no need to get all all the code from stored procedure.
script below will execute the procedure

EXEC AccntCalcClearSplitShares_regent
GO

Best regards,
Mike