DTS Designer Error

[Steve Carroll]

When launching any dts package in the designer an error "The system cannot
find the file specified." is being shown.
If I click OK I see the connection objects, but none of the task objects
show.

I've been researching this for a couple of days, and I've seen the articles
on www.sqldts.com where certain dll's are not registered, all to no avail.

I've tried uninstalling and reinstalling my client, again with no success.

I'm running SQL 2k sp 3a with the hotfix to bring it up to 818 on both my
desktop and servers.

The only thing I can think of that may be causing the problem is a custom
task.
Where / how are these registered? I'm wondering if on my local machine I
have a custom task that is no longer available and could be screwing things
up.

Any help would be GREATLY appreciated.

Thanks!
-Steve

[Allan Mitchell]

Custom tasks are dlls which need to be registered locally.

Did you read this article?

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Steve Carroll" <steve_carroll72@h_o_t_m_a_i_l.com> wrote in message
news:eDUICVvU...@TK2MSFTNGP09.phx.gbl...

[Steve Carroll]

Allan,

Thanks for your input.
Yes, I had read that article...
Specifically what I picked out was the fact that different service packs
could cause a problem.
However, I'm running the same version (according to @@version) on my client
workstation and the server (8.00.818)

Are custom tasks registered in COM just like any other object, or are there
additional hooks in the registry for this functionality?

Thanks,
-Steve

"Allan Mitchell" <al...@no-spam.sqldts.com> wrote in message
news:ukcnu8vU...@TK2MSFTNGP12.phx.gbl...

[Allan Mitchell]

You should just register them and be away. You then add them to your
toolbox. If you are seeing none of the Task objects then it does sound like
something is not registered correctly. I know you probably did but have
you reregostered the DTS dlls?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Steve Carroll" <steve_carroll72@h_o_t_m_a_i_l.com> wrote in message

news:eF9LIYwU...@TK2MSFTNGP09.phx.gbl...

[Rand Boyd [MSFT]]

One possible solution to this problem is to install another named instance
of SQL Server. This will cause all the client components to be reinstalled.
This has been know to resolve this type of probem. You can then remove the
named instance which should not remove the client components.

Rand
This posting is provided "as is" with no warranties and confers no rights.

[Darren Green]

"Steve Carroll" <steve_carroll72@h_o_t_m_a_i_l.com> wrote in message

news:eF9LIYwU...@TK2MSFTNGP09.phx.gbl...

> Allan,
>
> Thanks for your input.
> Yes, I had read that article...
> Specifically what I picked out was the fact that different service packs
> could cause a problem.
> However, I'm running the same version (according to @@version) on my
client
> workstation and the server (8.00.818)
>

@@version tells you the server version, not the client omponents, so were
you connected to a SQL instance on your workstation when checking the SP
level of your workstation?

> Are custom tasks registered in COM just like any other object, or are
there
> additional hooks in the registry for this functionality?

Yes and yes.

Have you used a custom task in the package that is not installed on the
machine where you get the error, such as the OLAP task, or another
third-party task?
--
Darren Green
http://www.sqldts.com