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