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.
No comments:
Post a Comment