COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not re

Hello,

I have a asp.net application that calls a DTS package. This application is running fine on my machine (where SQL Server and Web Server are running). When I moved the application to a Web Server (where SQL Server is not installed), I am getting the following error due to the DTS package.

COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not registered.

I tried every thing I could find on the web but with no luck.

Can someone please help me?
Many thanks in advance for your help.

A COM error means that something was not registered, so I am guessing the product SQL 2005 or DTS part was not installed in that computer, did you try to reinstall SQL 2005?|||

Your error is explained in the link below and I know the plain way to deploy DTS so if you decide to change your means of deployment post again so I can help. Hope this helps.

http://www.velocityreviews.com/forums/t93159-com-object-with-clsid-10020200eb1c11cfae6e00aa004a34d5-is-either-not-valid-or-not-registered.html

|||

Hiya guys.

Sorry for the late update!!!

Special thanks to Caddre!

Just want to give an update on this issue.
Basically, I have never been able to manage to sort this one out, despite viewing many articles on the net.

However, I just want to share one option to overcome this problem.

You can invoke your DTS package through a JOB using SP_START_JOB stored proc. This SP Instructs SQL Server Agent to execute a job immediately. This would do the job of executing the package!!! Of course, you will need the right to run the job (or use impersonation).

Hope this helps.

Collation problem

Hi
I need to correct some data in my SQL database due to a collation error
when I did the DTS from Paradox files to my SQL database I was using the "(Server default)" collation and now the extracted data has some weird chars
I need to use a Portuguese (Brazilian) collation, can i fix the error without loosing my curent data? If yes, how can I do it
Thanks!Marcus,
You can use ALTER TABLE xxx ALTER COLUMN yyy COLLATE collation_name
You should read the COLLATE topic. Whether you get what you want will
depend on whether some characters were remapped during the load into the
(server default) collation. (I don't think so.) You will have to drop
any indexes, statistics, etc. that you created on the columns.
Russell Fields
http://www.sqlpass.org/
2004 PASS Community Summit - Orlando
- The largest user-event dedicated to SQL Server!
"Marcus" <anonymous@.discussions.microsoft.com> wrote in message
news:DD900B9F-5D44-4ACE-9DAC-139EEC85591A@.microsoft.com...
> Hi!
> I need to correct some data in my SQL database due to a collation error!
> when I did the DTS from Paradox files to my SQL database I was using the
"(Server default)" collation and now the extracted data has some weird
chars!
> I need to use a Portuguese (Brazilian) collation, can i fix the error
without loosing my curent data? If yes, how can I do it?
>
> Thanks!