import an excel file

I tried to import an excel file using import/export wizard. When I launch
it, it gives me an error:
The SSIS Runtime object could not be created. Verify that DTS.dll is avaible
and registered. The wizard cannot continue and will terminate.
Additional Information:
Unable to cast COM object of type ...
Can anyone please tell me how to fix this? Thanks.Hi
You should find dts.dll in C:\Program Files\Microsoft SQL
Server\90\DTS\Binn\DTS.dll. You could try unregistering in re-registering
this using regsvr32 e.g. regsvr32 C:\Program Files\Microsoft SQL
Server\90\DTS\Binn\DTS.dll
Run this with the /u flag will unload the dll if necessary.
If you are not using SP1 you may want to load this to see if the problem is
resolved. If this does not cure the issue please post error numbers and the
full error message and any information from the event log as well.
HTH
John
"00KobeBrian" wrote:
> I tried to import an excel file using import/export wizard. When I launch
> it, it gives me an error:
> The SSIS Runtime object could not be created. Verify that DTS.dll is avaible
> and registered. The wizard cannot continue and will terminate.
> Additional Information:
> Unable to cast COM object of type ...
>
> Can anyone please tell me how to fix this? Thanks.
>
>|||Just want to clarify.
So do you want me to run regsvr32 C:\Program Files\Microsoft SQL
Server\90\DTS\Binn\DTS.dll /u
Then run regsvr32 C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll
and see if it works?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:D0926A82-FDA8-467A-A56A-6DC1FBE3CE21@.microsoft.com...
> Hi
> You should find dts.dll in C:\Program Files\Microsoft SQL
> Server\90\DTS\Binn\DTS.dll. You could try unregistering in re-registering
> this using regsvr32 e.g. regsvr32 C:\Program Files\Microsoft SQL
> Server\90\DTS\Binn\DTS.dll
> Run this with the /u flag will unload the dll if necessary.
> If you are not using SP1 you may want to load this to see if the problem
> is
> resolved. If this does not cure the issue please post error numbers and
> the
> full error message and any information from the event log as well.
> HTH
> John
> "00KobeBrian" wrote:
>> I tried to import an excel file using import/export wizard. When I launch
>> it, it gives me an error:
>> The SSIS Runtime object could not be created. Verify that DTS.dll is
>> avaible
>> and registered. The wizard cannot continue and will terminate.
>> Additional Information:
>> Unable to cast COM object of type ...
>>
>> Can anyone please tell me how to fix this? Thanks.
>>|||I got it now. Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:D0926A82-FDA8-467A-A56A-6DC1FBE3CE21@.microsoft.com...
> Hi
> You should find dts.dll in C:\Program Files\Microsoft SQL
> Server\90\DTS\Binn\DTS.dll. You could try unregistering in re-registering
> this using regsvr32 e.g. regsvr32 C:\Program Files\Microsoft SQL
> Server\90\DTS\Binn\DTS.dll
> Run this with the /u flag will unload the dll if necessary.
> If you are not using SP1 you may want to load this to see if the problem
> is
> resolved. If this does not cure the issue please post error numbers and
> the
> full error message and any information from the event log as well.
> HTH
> John
> "00KobeBrian" wrote:
>> I tried to import an excel file using import/export wizard. When I launch
>> it, it gives me an error:
>> The SSIS Runtime object could not be created. Verify that DTS.dll is
>> avaible
>> and registered. The wizard cannot continue and will terminate.
>> Additional Information:
>> Unable to cast COM object of type ...
>>
>> Can anyone please tell me how to fix this? Thanks.
>>|||Hi
Does this mean it is working?
Running regsvr32 C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll
whilst it is registered would not cause any problems, but it is a good idea
to try and unregister it first.
John
"00KobeBrian" wrote:
> I got it now. Thanks.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:D0926A82-FDA8-467A-A56A-6DC1FBE3CE21@.microsoft.com...
> > Hi
> >
> > You should find dts.dll in C:\Program Files\Microsoft SQL
> > Server\90\DTS\Binn\DTS.dll. You could try unregistering in re-registering
> > this using regsvr32 e.g. regsvr32 C:\Program Files\Microsoft SQL
> > Server\90\DTS\Binn\DTS.dll
> >
> > Run this with the /u flag will unload the dll if necessary.
> >
> > If you are not using SP1 you may want to load this to see if the problem
> > is
> > resolved. If this does not cure the issue please post error numbers and
> > the
> > full error message and any information from the event log as well.
> >
> > HTH
> >
> > John
> >
> > "00KobeBrian" wrote:
> >
> >> I tried to import an excel file using import/export wizard. When I launch
> >> it, it gives me an error:
> >>
> >> The SSIS Runtime object could not be created. Verify that DTS.dll is
> >> avaible
> >> and registered. The wizard cannot continue and will terminate.
> >>
> >> Additional Information:
> >> Unable to cast COM object of type ...
> >>
> >>
> >> Can anyone please tell me how to fix this? Thanks.
> >>
> >>
> >>
>
>