Pentaho

Hi All

PDI 9.0

Simple job

MS SQL connection

Table input -> tableouput

tableouput table :

CREATE TABLE [dbo].[a02](

   [ProductID] [int] NOT NULL IDENTITY(1,1)

  ..

I need to write IDENTITY explicitly

in SSMS I run

set IDENTITY_INSERT a00 ON

and do insert ok.

In pentaho I got error

Table output.0 - Cannot insert explicit value for identity column in table 'a00' when IDENTITY_INSERT is set to OFF.

trying to run in SQl : set IDENTITY_INSERT a00 ON

Before 

SQL -> table input -> table output

but same error occured.

Seems set IDENTITY_INSERT a00 ON runs in DIFFerent SESSION

then table output

How can I run set IDENTITY_INSERT a00 ON in same session

or point out to use it ;