error while using openrowset

#1

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
*')

Thanks

#2

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

"kresna" <kresnark (AT) yahoo (DOT) com> wrote

Quote:

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
*')

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

error while using openrowset

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

error while using openrowset - 08-21-2003 , 02:16 AM

Re: error while using openrowset - 08-21-2003 , 03:04 AM