Hi, I tried to trigger the SSIS package to port data from SQL to DB2 using ADO.NET Destination by windows service. ,it throws the following error: -1073446879,0x,The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Writes to a database using ADO.NET provider.;Microsoft Corporation; Microsoft SqlServer v10; 2007 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0". Please guide me to overcome this issue. Thanks, Dhinesh

Did you load a DB2 driver on your machine?Chuck

Hii Dhinesh, use the OLEDB counterpart.I trust this thread will help you set all up: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/4128e62f-92d1-4125-baa3-fdd9fed59d48/Arthur My Blog

Yes. Its working fine in VS 2008. From the machine where windows service installed its throwing an error.

Do you have SQL Server Integration Services installed on the machine where the service is running? Talk to me now on

What windows service are you talking about? This error could be a result of different ADO providers in your dev vs prod and/or even SSIS buildsArthur My Blog

The error caused due to different versions of SSIS in prod and dev server. Finaly i resolved the issue . Thanks for the help.