Hi,

Just trying to import data from an excel 2000 spreadsheet into a sql
table using dts and getting the following error - "Could not create an
instance of the DTS Package"

Any ideas?

Thanks
TGB


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I would

1. Try reregistering the DTS dlls

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

2. Service Packing your SQL Server.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"tgb" <tgb (AT) default (DOT) com> wrote