@dinesh-2 Asanka

I have experimented your setting, and ran my package with "SQL Server Destination" created for a remote server.But my package failed again with the same error.

Here is what I did-

1). I have added my domain account in :

Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment\Create global objects

2). Executed the pkg that used the "SQL Server Destination" component in the "Data Flow Task". The Result :: Failed

Error Message:

[SQL Server Destination [1978]] Error: Unable to prepare the SSIS bulk insert for data insertion.

[DTS.Pipeline] Error: component "SQL Server Destination" (1978) failed the pre-execute phase and returned error code 0xC0202071.

3). Replaced "SQL Server Destination" with "OLE DB Destination" and Package succeded.

Is there any correction needed, in making my "SQL Server Destination" work as you have explained.

Barely 'Alive',

[font="Comic Sans MS"]Vampire[/font]