Sorry for my bad english.
in my job is one dataflow with sql transform, query and target table (LOG).
SQL Text is :
in this SP next content:
CREATE TABLE #t(...)
INSERT INTO #t SELECT (...)
INSERT INTO Table1
SELECT(...) FROM #t
SELECT (row with error number, error message)
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.