Hello All,

I am attempting to access a DTS Package stored on SQL server using the
OpenRowSet command, however every time I attempt this I am presented with
the following error message:

Could not create an instance of OLE DB provider 'DTSPackageDSO'.
OLE DB error trace [Non-interface error: CoCreate of DSO for DTSPackageDSO
returned 0x80040154].

I am making use of Windows integrated security and the DTS package name is
Test, thus my sql statement is as follows:
SELECT * FROM OPENROWSET('DTSPackageDSO', '/NTest', 'Select *')

I am accessing the server via SQL Query analyzer.

Can anybody help ?

Regards, Brian.

Have you set a task within to be a DSO Rowset provider (Workflow properties)
?

--

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



"Brian" <brian.perks (AT) investecmail (DOT) com> wrote