Skip to Content
0
Former Member
Jan 21, 2011 at 12:38 PM

BOBJ DI 12.2.2.1| SQL Transform call stored procedure on MSSQL 2008 FAIL

26 Views

Hello everyone!

Sorry for my bad english.

in my job is one dataflow with sql transform, query and target table (LOG).

SQL Text is :

EXEC dbo.ProcName

in this SP next content:

BEGIN TRY

CREATE TABLE #t(...)

INSERT INTO #t SELECT (...)

...

INSERT INTO Table1

SELECT(...) FROM #t

ENDTRY

BEGIN CATCH

SELECT (row with error number, error message)

END CATH

IF NOERROR SELECT (row with no error and rows affected)

When I run it from Management Studio all is OK. Data is successfully inserted into Table1and rRow with rowcount was inserteg into LOG.

But When I run it in Job on JobServer exact row inserting into LOG BUT! no data inserting into Table1. and rowcount is equal in both cases.

What's happening?

Help please.