SSIS insert bulk of data into remote table with trigger

Ramy Mahrous

Rate me:

5.00/5 (1 vote)

17 Nov 2009CPOL

14K

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

No downloads associated with this content

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

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

License

Comments and Discussions