sql server

[vsi]

When I am trying to insert data . I am gettin this error

source--flatfile
intermediate stage --- Transformer
target--sqlserver


SQLServer_Enterprise_346,0: Failure during execution of operator logic.

SQLServer_Enterprise_346,0: Internal Error: (0): odbcupsert.C: 846

can anyone suggest me what the error might be

[mctny]

When I am trying to insert data . I am gettin this error

source--flatfile
intermediate stage --- Transformer
target--sqlserver


SQLServer_Enterprise_346,0: Failure during execution of operator logic.

SQLServer_Enterprise_346,0: Internal Error: (0): odbcupsert.C: 846

can anyone suggest me what the error might be

I think there is a problem in the derivation of the columns inside the transformer you are using.

[kumar_s]

Reset the job, from the log, you will find an entry as "From Previous log...". That will at times come up with most usfull information.

[ray.wurlod]

Set up a rejects link from the SQL Server Enterprise stage. This will capture any row rejected by the database. You can then inspect the data and make an informed decision as to the cause of the problem.

[kumar_s]

Not sure if rejects can capture the row that cause the abort.