Groups | Blog | Home
all groups > sql server dts > august 2003 >

sql server dts : error while using openrowset


kresna
8/21/2003 12:16:39 AM
I get an errror like this :

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

What does it means ?

Is my syntax correct ?
SELECT * FROM OPENROWSET
('DTSPackageDSO', '/Usa /Psqladmin /S /dts_dso2', 'Select
*')

Allan Mitchell
8/21/2003 9:04:27 AM
What is your OS and SQL Server edition and where are you asking for the
DTSPackageDSO?


--

----------------------------
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



[quoted text, click to view]

AddThis Social Bookmark Button