Hi,
I have created a simple DTS package called NP that has a connection to my
local SQL server and a SQL task that returns all the records for a single
table.

I have saved that package off to c:\NP.DTS and then created a linked server
(again on my local server) to this DTS package using exec sp_addlinkedserver
'DTS2','Np','DTSPackageDSO','/fc:\p.dts'

If I then run this query...select * from DTS2...SQLT... I get the following
error...Could not open table 'SQLT' from OLE DB provider 'DTSPackageDSO'.
Unknown provider error.
OLE DB error trace [OLE/DB Provider 'DTSPackageDSO' IOpenRowset::OpenRowset
returned 0x80040433: Unknown provider error.].

If I attempt the same thing, but through Vb using a UDL to point to my DTS
package and ADOBD to connect, and run this...cn.Execute "SELECT * FROM
SQLT"... I get this error...Run-Time error '-2147220429
(80040433)':Automation Error... There is nothing on the Microsoft site for
the error numbers above - so not a very usefull error message.

At least with the above command ...cn.Execute "SELECT * FROM SQLT"... I know
that it can see the contents of the DTS package because if I change the
'SQLT' (my SQL Task step) to say, SQLT1, I get this error...Run-Time error
'-2147220501 (800403eb)': Step 'SQLT1' was not found.

To me this indicates that it can see the package, can see the step but can't
retrieve the rowset exposed by the step even though the Workflow Property
Option of 'DSO rowset Provider' is checked.

Any ideas why this is happening?
Thanks
Paul