Posted by Daniel Wetzler on 10/02/72 11:56

Hi Roy,

thanks for your answer.

Here's the table definition :


CREATE TABLE [dbo].[Variables] (
[ID] [varchar] (140) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Var_ref] [int] NOT NULL ,
[Group_Ref] [int] NULL ,
[Machines_Ref] [int] NULL ,
[TransfersID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[Compatibility] [int] NULL ,
[CompatibilityL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Category] [int] NULL ,
[CategoryL1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[AnalysisResponsible] [tinyint] NULL ,
[AnalysisPriority] [int] NULL ,
[AnalysisDelta] [int] NULL ,
[AnalysisDeltaValue] [varchar] (30) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[Value] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Length] [int] NULL ,
[Address] [int] NULL ,
[Offset] [int] NULL ,
[Title1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title2] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title3] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title4] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle1] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle2] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle3] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[AggregationTitle4] [nvarchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Best regards,

Daniel



Roy Harvey schrieb:

> Posting the table definition (CREATE TABLE) would help a lot.
>
> Roy Harvey
> Beacon Falls, CT
>
> On 24 Aug 2006 02:07:36 -0700, "Daniel Wetzler"
> <Daniel.Wetzler@sig.biz> wrote:
>
> >Dear MSSQL- experts,
> >
> >I have a strange problem with SQLSERVER 2000.
> >I tried to export a table of about 40000 lines into a text file using
> >the Enterprise manager
> >export assitant. I was astonished to get an exported text file of about
> >400 MB instead 16 MB which is the normal size of that data.
> >By examining this file with a text editor I found that the file
> >included alongside the data of my table MANY zeros which caused the big
> >file size.
> >
> >Does someone of you have an idea what could cause the export of
> >trillions zeros into my textfile and how to only export the significant
> >data of my table ?
> >
> >Best regards,
> >
> >Daniel

• Next in forum: Replication performance - how to measure it ?
• Prev in forum: Re: Help me with this query please.
• Thread view: Re: Problem with export of a table to a text file

[Reply to this message]