Hi anurags99

Let me know if I'm teaching you to suck eggs at any time.

To enlist MSDTC on your target machine you will need to set some options in MSDTC security configuration. (To get to this screen, open component services in Administrative Tools, expand component services and expand computersn then rightclick My computer, select the MSDTC Tab and click the Security configuration Button)

1. Check the "Network DTC Access" Checkbox in the MSDTC Security configuration dialog. This will enable you to set the following options

2. Under Client and Administrattion, check the "Allow remote Clients" checkbox

3. Under Transaction Manager communication, check the "Allow Inbound" checkbox

4. If your two servers are on the same domain, then you should be able to use Mutual Authentication Required. If this still isn't working try chaging the checkbox to No Authentication

To Enlist MSDTC on your source machine, you will need to set the following MSDTC security configurations

1. Check the "Network DTC Access" Checkbox in the MSDTC Security configuration dialog. This will enable you to set the following options

3. Under Transaction Manager communication, check the "Allow Outbound" checkbox

4. If your two servers are on the same domain, then you should be able to use Mutual Authentication Required. If this still isn't working try chaging the checkbox to No Authentication

Additionally you will obviously need to make sure that the account that is running the SSIS package on the source server A has privileges to connect to target server B and that it has sufficient privileges for each of the tables, stored procedures etc used in the package

Cheers