DTS designer error

When I open my DTS package at my PC ( Client ) .There is an error message show like below .
DTR Designer Error.
There was a problem retriving the list of OLE DB providers.
No. Provider is selected .TO continue,you must select a valid provider.
Please helpHowdy

Delete the server registration in EM and re-register the server.

Post back if problems.

Cheers

SG.|||What is the level of service pack of SQL on the client machine?
Ensure to maintain similar service pack on Server and on client as well.|||Originally posted by sqlguy7777
Howdy

Delete the server registration in EM and re-register the server.

Post back if problems.

Cheers

SG.

I have already done as your mention but it still show the same error message

Any idea ??|||Originally posted by Satya
What is the level of service pack of SQL on the client machine?
Ensure to maintain similar service pack on Server and on client as well.

How can I check the service pack verion of both server and client ? Please introduce me

Thanks|||SELECT serverproperty('ProductLevel')

Regards!!|||select @.@.version;

This will give you the details of OS level as well as SQL Server level.|||This causes due to .DLL mismatch or even MDAC version between client and server machines, so ensure you have all the similar levels.

This @.@.Version or Serverproperty will give you version on server for SQL Server and on client machine ensure to run service pack for SQL again which might resolve the issue.