SSIS error 0xC0202071

If you are importing to a remote SQL server, you may recieve a 0xC0202071 error code. While this works locally on a SQL Server, the only way I've found to get around this for remote servers is to replace the destination of 'SQL Server Destination' with 'OLE DB Destination'.

No cause yet determined and BIDS truncates the error description so it's not very helpful either. 

Comments Closed.