Resolving issues with Custom SSIS Components

Ssis  Bids  Sql 
- Ravichandra on Feb 23 '18
- viewed 228 times

In general, People use existing SSIS components to perform ETL operations on data. But there would be a need to create a custom component to reuse and to have plug and play options for set of distinct things (like creating a context, closing a context etc). In such cases you have to register your custom components in GAC. Also should place your custom DLLs in : C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn

We should always make sure that the custom components associated DLLs (like referred DLLs in Script task) also are kept at the above sited folder and GAC.

About the author

Ravichandra
.Net Developer



Leave your comments on this post here


SIGN UP AND GET LATEST UPDATES.

Recent Posts

×
 

Liked this article?

Subscribe with your email and get updates when ever a new article is posted.

By subscribing you agree to our privacy terms. We promise that we do not sell your data.