DTS in SQL Server Workgroup or Personal Edition?

Hi,
I see that DTS is not available in the Workgroup edition of SQL server.
Does anyone know if it's available in the Personal edition?
If DTS is not available in an edition of SQL server, can I still use DTSPUMP
functions in VB on the SQL server?
Thanks in advance,
--
Christy Warner
www.autoaudit.comHi
DTS is supported on personal edition although the following link does not
include the new workgroup edition, I would expect it to at least have
deployment capabilities so you should be able to distribute your application
s.
http://msdn.microsoft.com/library/d...br />
1cdv.asp
You may want to confirm this with you vendor or local Microsoft office.
John
"ChristyWarner" wrote:

> Hi,
> I see that DTS is not available in the Workgroup edition of SQL server.
> Does anyone know if it's available in the Personal edition?
> If DTS is not available in an edition of SQL server, can I still use DTSPU
MP
> functions in VB on the SQL server?
> Thanks in advance,
> --
> Christy Warner
> www.autoaudit.com
>

DTS Import not working after SP3a upgrade

I have a DTS package that is importing a fixed length file.
After installing SP3a (on PERSONAL & DEVELOPER edition) it will not
allow me to assign more than 125 fixed length column positions.
After hitting the Finish & OK button it just wipes out the column
settings.

I've reinstalled both Personal & Developer edition. DTS will allow
more than 125 prior to the service pack.You may be seeing a side effect of installing SP3 and the problem seen by
others after aplying this SP is here. There is a fix

814113 - FIX DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
http://support.microsoft.com/defaul...KB;EN-US;814113

--
--

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

"shinobi332" <darinmiller@.earthlink.net> wrote in message
news:afdc1036.0406011922.2359a387@.posting.google.c om...
> I have a DTS package that is importing a fixed length file.
> After installing SP3a (on PERSONAL & DEVELOPER edition) it will not
> allow me to assign more than 125 fixed length column positions.
> After hitting the Finish & OK button it just wipes out the column
> settings.
> I've reinstalled both Personal & Developer edition. DTS will allow
> more than 125 prior to the service pack.|||That worked perfectly.
Thanks Allan!!!

"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message news:<40bd7127$0$4589$db0fefd9@.news.zen.co.uk>...
> You may be seeing a side effect of installing SP3 and the problem seen by
> others after aplying this SP is here. There is a fix
> 814113 - FIX DTS Designer May Generate an Access Violation After You
> Install SQL Server 2000 SP3
> http://support.microsoft.com/defaul...KB;EN-US;814113
>
> --
> --
> 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
>
> "shinobi332" <darinmiller@.earthlink.net> wrote in message
> news:afdc1036.0406011922.2359a387@.posting.google.c om...
> > I have a DTS package that is importing a fixed length file.
> > After installing SP3a (on PERSONAL & DEVELOPER edition) it will not
> > allow me to assign more than 125 fixed length column positions.
> > After hitting the Finish & OK button it just wipes out the column
> > settings.
> > I've reinstalled both Personal & Developer edition. DTS will allow
> > more than 125 prior to the service pack.