Cannot Import from Filemaker !

Hi all,
I am trying to import data from Filemaker Pro 5 database into SQL Server
2000 using DTS.
The problem is that big text columns are truncated to 255 chars.
Despite I use ntext or text or nvarchar(4000) in destination table, datas
are systematically truncated.
What hapens ?
Please help !
EricIt sounds rather like this problem but this problem has text files. Can you
workaround in a similar fashion ?
DataPump truncates delimited fields to 255 characters
(http://www.sqldts.com/default.aspx?297)
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Eric" <tritet@.free.fr> wrote in message
news:bo604k$6ks$1@.reader1.imaginet.fr...
> Hi all,
> I am trying to import data from Filemaker Pro 5 database into SQL Server
> 2000 using DTS.
> The problem is that big text columns are truncated to 255 chars.
> Despite I use ntext or text or nvarchar(4000) in destination table, datas
> are systematically truncated.
> What hapens ?
> Please help !
> Eric
>
>|||The problem is still there after installing SP3 for Sql server.
The problem is that I want to import data from Filemaker to sql server.
It is an import action, not export as related in this Bug report :
247527 FIX: DTS May Truncate Characters When You Export a Table Column of
Character Data Type to a Text File
Occurs only with strings that are over 255 in length under certain
conditions.
Corrected in SQL Server 2000 SP2.
"Allan Mitchell" <allan@.no-spam.sqldts.com> a écrit dans le message de
news:u2Dkr$ioDHA.2416@.TK2MSFTNGP10.phx.gbl...
> It sounds rather like this problem but this problem has text files. Can
you
> workaround in a similar fashion ?
> DataPump truncates delimited fields to 255 characters
> (http://www.sqldts.com/default.aspx?297)
> --
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "Eric" <tritet@.free.fr> wrote in message
> news:bo604k$6ks$1@.reader1.imaginet.fr...
> > Hi all,
> >
> > I am trying to import data from Filemaker Pro 5 database into SQL Server
> > 2000 using DTS.
> >
> > The problem is that big text columns are truncated to 255 chars.
> >
> > Despite I use ntext or text or nvarchar(4000) in destination table,
datas
> > are systematically truncated.
> >
> > What hapens ?
> >
> > Please help !
> >
> > Eric
> >
> >
> >
>