Re: XP SP2 screwing up DTS transform on Text field

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 18:35:54 +0100

Oh

I will try and repro

So the test is create a table with a TEXT attribute and export to text file
with the OS being XP SP2 

-- 
-- 
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
"josh" <smith-josh@aramark.com> wrote in message
news:098601c491c0$56ae7a40$a401280a@phx.gbl...
> Are you asking what errors I get?  because, yes, I do get
> them!  and to be more specific, the error I get
> is "unspecified".  ooooh.....   how's that for helpful?!
>
>
> >-----Original Message-----
> >Errors?
> >
> >I am about to put SP2 on  my dev box
> >
> >-- 
> >-- 
> >
> >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
> >
> >
> >"josh" <smith-josh@aramark.com> wrote in message
> >news:0c5001c49103$7cf8b520$a401280a@phx.gbl...
> >> HELP!  has anybody else experienced this?
> >>   Emperical evidence has shown that a DTS package that
> >> converts a table, containing a text field, with an
> >> ActiveX transform task used to work, and now fails with
> >> XP SP2 installed.  Uninstalling SP2 brougt back a
> >> successful transformation.  I searched for quite a long
> >> time for bad data or some scenario that should cause it
> >> to fail, but could find none.  Interstingly, if each
> >> record was pumped/transformed one at a time, they all
> >> worked.  As soon as the Source query started returning
> >> more than one record, it stopped.  This is not good.
> >>   Any insight out there?
> >>
> >> Thanks,
> >> Josh
> >>
> >
> >
> >.
> >

Relevant Pages