Thanks Guys ,

I have increased time out session from 600 to 2000 and SSIS package is running on 10.1 version. I haven't found the Root Cause of this issue. Some...

Thanks for reply but in error message it don't indicate its a proxy issue, it says below error.

OLE DB" Description: SSIS Error Code DTS_E_OLEDBERROR. An...

Thank you so much , once I am done with this testing I will update.

Thank you J Good & Hanshi

What I did I took a backup from Publication server and restored it to Subscription server. The database size match's and everything looks fine but when I build replication the...

What I did I took a backup from Publication server and restored it to Subscription server. The database size match's and everything looks fine but when I build replication...

Thanks A lot

So I was able to remove the replication that command went fine, but there is no subscription & Publication is still there.

No there is no Subscriptions there

Giving error

Can not drop the Publication because at least one Subscription exists for this Publication.

Drop all Subscription to the Publication before attempting to drop the Publication.

Now I am...

any one please help

Thank You

I have another question when I am looking at distribution database I am seeing a lot of job.

Our Database get refreshed every month and it breaks the replication and...

Thanks A lot for your help 🙂

no it does not exist on subscriber.

also when I created replication it created a lot of jobs at Distribution database and in Replication Monitor I am seening old replication Publication...