Error al definir archivo de destino TXT desde una tabla con 39 campos

28/07/2004 - 22:49 por Fabian Ramirez | Informe spam
Estoy definiendo un DTS para pasar los registros de una
tabla con 39 campos hacia un archivo de Texto. Al definir
las columnas del archivo de texto destino oprimiendo el
boton definir columnas el Administrador Corporativo
solamente se cierra.
Relizando el mismo procedimiento con tablas de menos
campos funciona correctamente.

Aqui la estructura de la tabla

CREATE TABLE [SYNC_TRANSAUTH] (
[Account] [char] (19) COLLATE
Modern_Spanish_CI_AS NOT NULL ,
[Flags] [int] NULL ,
[Master] [char] (19) COLLATE Modern_Spanish_CI_AS
NULL ,
[TimeIn] [datetime] NOT NULL ,
[InqCode] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[TType] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[RefNo] [char] (12) COLLATE Modern_Spanish_CI_AS
NOT NULL ,
[TerId] [char] (8) COLLATE Modern_Spanish_CI_AS
NULL ,
[MerId] [char] (15) COLLATE Modern_Spanish_CI_AS
NULL ,
[Application] [char] (20) COLLATE
Modern_Spanish_CI_AS NOT NULL ,
[Source] [int] NULL ,
[ExpDate] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[CtryCode] [char] (3) COLLATE
Modern_Spanish_CI_AS NULL ,
[CurrCode] [char] (3) COLLATE
Modern_Spanish_CI_AS NULL ,
[AutId] [char] (6) COLLATE Modern_Spanish_CI_AS
NULL ,
[Trace] [char] (6) COLLATE Modern_Spanish_CI_AS
NULL ,
[RspCode] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[RCode] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[LAmount] [decimal](18, 6) NOT NULL ,
[FAmount] [decimal](18, 6) NOT NULL ,
[ExcRate] [decimal](18, 6) NOT NULL ,
[AdqId] [char] (6) COLLATE Modern_Spanish_CI_AS
NULL ,
[Entry] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[CatCode] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[Track1] [char] (80) COLLATE Modern_Spanish_CI_AS
NULL ,
[Track2] [char] (40) COLLATE Modern_Spanish_CI_AS
NULL ,
[Balance] [decimal](18, 6) NOT NULL ,
[Status] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[FreqSale] [int] NULL ,
[FreqCash] [int] NULL ,
[Reversed] [tinyint] NULL ,
[Product] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[Applied] [tinyint] NOT NULL ,
[Processed] [tinyint] NOT NULL ,
[NII] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[LDATE] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[LTIME] [char] (6) COLLATE Modern_Spanish_CI_AS
NULL ,
[Sequency] [numeric](18, 0) IDENTITY (1, 1) NOT
NULL ,
[CutNumber] [numeric](18, 0) NOT NULL
) ON [PRIMARY]
GO
 

Leer las respuestas

#1 MAXI
29/07/2004 - 00:08 | Informe spam
Hola, que service pack y MDAC usas?




Maxi

Buenos Aires - Argentina

Desarrollador .NET 3 Estrellas

Mail: Maxi_accotto[arroba]speedy.com.ar

Msn Messager:


"Fabian Ramirez" escribió en el mensaje
news:61df01c474e4$5c15baf0$
Estoy definiendo un DTS para pasar los registros de una
tabla con 39 campos hacia un archivo de Texto. Al definir
las columnas del archivo de texto destino oprimiendo el
boton definir columnas el Administrador Corporativo
solamente se cierra.
Relizando el mismo procedimiento con tablas de menos
campos funciona correctamente.

Aqui la estructura de la tabla

CREATE TABLE [SYNC_TRANSAUTH] (
[Account] [char] (19) COLLATE
Modern_Spanish_CI_AS NOT NULL ,
[Flags] [int] NULL ,
[Master] [char] (19) COLLATE Modern_Spanish_CI_AS
NULL ,
[TimeIn] [datetime] NOT NULL ,
[InqCode] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[TType] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[RefNo] [char] (12) COLLATE Modern_Spanish_CI_AS
NOT NULL ,
[TerId] [char] (8) COLLATE Modern_Spanish_CI_AS
NULL ,
[MerId] [char] (15) COLLATE Modern_Spanish_CI_AS
NULL ,
[Application] [char] (20) COLLATE
Modern_Spanish_CI_AS NOT NULL ,
[Source] [int] NULL ,
[ExpDate] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[CtryCode] [char] (3) COLLATE
Modern_Spanish_CI_AS NULL ,
[CurrCode] [char] (3) COLLATE
Modern_Spanish_CI_AS NULL ,
[AutId] [char] (6) COLLATE Modern_Spanish_CI_AS
NULL ,
[Trace] [char] (6) COLLATE Modern_Spanish_CI_AS
NULL ,
[RspCode] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[RCode] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[LAmount] [decimal](18, 6) NOT NULL ,
[FAmount] [decimal](18, 6) NOT NULL ,
[ExcRate] [decimal](18, 6) NOT NULL ,
[AdqId] [char] (6) COLLATE Modern_Spanish_CI_AS
NULL ,
[Entry] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[CatCode] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[Track1] [char] (80) COLLATE Modern_Spanish_CI_AS
NULL ,
[Track2] [char] (40) COLLATE Modern_Spanish_CI_AS
NULL ,
[Balance] [decimal](18, 6) NOT NULL ,
[Status] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[FreqSale] [int] NULL ,
[FreqCash] [int] NULL ,
[Reversed] [tinyint] NULL ,
[Product] [char] (2) COLLATE Modern_Spanish_CI_AS
NULL ,
[Applied] [tinyint] NOT NULL ,
[Processed] [tinyint] NOT NULL ,
[NII] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[LDATE] [char] (4) COLLATE Modern_Spanish_CI_AS
NULL ,
[LTIME] [char] (6) COLLATE Modern_Spanish_CI_AS
NULL ,
[Sequency] [numeric](18, 0) IDENTITY (1, 1) NOT
NULL ,
[CutNumber] [numeric](18, 0) NOT NULL
) ON [PRIMARY]
GO



Preguntas similares