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

Preguntas similare

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



Respuesta Responder a este mensaje
#2 Anonimo
29/07/2004 - 01:02 | Informe spam
Sql server 2000 Service Pack 3 8.00.760
Standard Edition on Windows NT 5.0 (Build 2195: Service
Pack 4)

MDAC VERSION 2.7 SP1

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



.

email Siga el debate Respuesta Responder a este mensaje
Ads by Google
Help Hacer una preguntaRespuesta Tengo una respuesta
Search Busqueda sugerida