db is in simple recovery model.

no replication configured.

But some CDC jobs are setup , is this the issue ?

is it possible to limit the number of errorlog files to 2 ?

cdc is enabled for the database.

yes , sys.databases has is_cdc_enabled =1 for that database.

A. the user have enough/right permissions for the SSIS execution

B. No result , i mean no dbs showing as cdc enabled.

actually i checked your query...

yes all servers are 2012.

yes i am using SSIS and CDC components, yes i checked the credentials and all are valid.

No changes\updates .

it was running fine in one server but its failing now , and implementing this first time in one more server.

i am facing the same errors in both...

actually it inserting simple single record.

we estimated time should be milli seconds, but its taking 2min.

need to find what might be causing this. not getting any clue.

yes this is the specific insert query a problem .

thanks!!

foundout the CDC state by using below query.

select is_cdc_enabled ,* from sys.databases where name = 'xxxxx'

attached error .

yes, i tried to restore without keep replication also...

received same error.

yes , i restored the db with keep_replication also again.

its showing below error after restoration.

Processed 448 pages for database 'abc', file 'abc_Data' on file 1.

Processed 2 pages for database'abc', file...