Export data into text file

#1

Hello,
I have to export data from one table to a file (any type) in order to import it after to another sql server database.
The table has one nvarchar column of 2000 possible size. If i export it to a text file with delimited format my column is cut off to 255 characters, if i export it to a text file with fixed column size i cannot import it afterwords.
Pls help me to find the way of transferring such long data
Any help is very much appreciated

--
---------------------
Best regards,
Gosia Ndreu

#2

In article <uFUbLV9mEHA.3712 (AT) TK2MSFTNGP15 (DOT) phx.gbl>, Mndr wrote:

Quote:

Hello,
I have to export data from one table to a file (any type) in order
to import it after to another sql server database.
The table has one nvarchar column of 2000 possible size. If i export
it to a text file with delimited format my column is cut off to 255
characters, if i export it to a text file with fixed column size i
cannot import it afterwords.
Pls help me to find the way of transferring such long data
Any help is very much appreciated

You may well be seeing this

http://support.microsoft.com/?kbid=247527

--

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Export data into text file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Export data into text file - 09-16-2004 , 05:09 AM

Re: Export data into text file - 09-18-2004 , 05:40 AM