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.