SSIS insert bulk of data into remote table with trigger

Ramy Mahrous

Rate me:

5.00/5 (1 vote)

17 Nov 2009CPOL

14.1K

hmmm, nice we have SSIS it makes life easier but it usually comes with non-understood problems like "SQL Server Destination" (2185) failed with error code 0xC0202071 it means when you insert data into table in remote SQL Server don't use SQL Server Destination component however use OLE DB Destinatio

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Ramy Mahrous

Software Developer LINK Development

Egypt

Business Intelligence Developer at LINK Development which is a wholly subsidiary of LINKdotNET, graduated from Faculty of Computers and Information | Helwan University, Cairo, Egypt | 2003 - 2007, Computer Science as a Major, he has a passion for community, latest knowledge delivering and Q&A forums.

SSIS insert bulk of data into remote table with trigger

Alternatives

License

Comments and Discussions