Hello, all. Running SQL 2K. I have several DTS packages
that I've always been able to open successfully without a
fuss. Since a few days ago, I've been getting a DTS
Designer Error when trying to open my packages. The error
says "Class Not Registered". All packages do plain-
vanilla import/export data to/from SQL to comma delimited
files. Nothing fancy, and like I said; I've always been
able to open them without these error messages.

Can anyone shed light on what may have caused this?

Tia!
Roz

Often this happened when opening a 2000 package on a 7 server (<Sp3) when no
password had been assigned to the package
OR
There was a task used in the package that worked at design time PC but not
on the Runtime Server


Is it possible that something has stamped on the DTS dlls on the running PC?
Can you open them anywhere else Xcept for your PC?



--

----------------------------

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


"Roz" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi Roz

I am newbie to SQL DTS and looking for some sample examples of import/export data to/from sql server 2000 and comma delimited files. Can you give some examples how u did it

Thanks
ganes


----- Roz wrote: ----

Hello, all. Running SQL 2K. I have several DTS packages
that I've always been able to open successfully without a
fuss. Since a few days ago, I've been getting a DTS
Designer Error when trying to open my packages. The error
says "Class Not Registered". All packages do plain
vanilla import/export data to/from SQL to comma delimited
files. Nothing fancy, and like I said; I've always been
able to open them without these error messages

Can anyone shed light on what may have caused this

Tia
Ro

Have a look here

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

And Here

Importing A Text File Using The DTS Wizard
(http://www.sqldts.com/default.aspx?276)

--
--

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


"ganesh" <anonymous (AT) discussions (DOT) microsoft.com> wrote

you give some examples how u did it?

Thanks Allan for very informative sites. Can you please give some other sites having detailed information on DTS object model like creating connections, packages, Datapumps task, bulkinserts tasks, steps etc as I want to write programs in vb.ne

Cheers
ganesh

----- Allan Mitchell wrote: ----

Have a look her

Building a Package in the DTS Designe
(http://www.sqldts.com/default.aspx?278

And Her

Importing A Text File Using The DTS Wizar
(http://www.sqldts.com/default.aspx?276

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP
www.SQLDTS.com - The site for all your DTS needs
I support PASS - the definitive, global communit
for SQL Server professionals - http://www.sqlpass.or


"ganesh" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:2E1DE983-B09E-4911-9A33-4ECAA45FFA1E (AT) microsoft (DOT) com..
you give some examples how u did it

To be honest the best way of doing this (few people build packages from
scratch I think) is

1. Build packages in Designer
2. Save to VB .bas modules
3. Have BOL handy for reference
4. Always bookmark www.SQLDTS.com
5. Play.

I would maybe "Google" for stuff as well but besides that I think you are
set.

--
--

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


"ganesh" <anonymous (AT) discussions (DOT) microsoft.com> wrote

connections, packages, Datapumps task, bulkinserts tasks, steps etc as I
want to write programs in vb.net

No. DTS was pre .Net (well RTM anyway).

You will need to change portions of the code but not so much that it will be
worth you just starting again.

BOL = Books Online. SQL Server Help Files



--
--

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


"ganesh" <anonymous (AT) discussions (DOT) microsoft.com> wrote

BOL means?