I need to create a DTS to transfer data from AS400 to SQL Server.
I used this sintax:
SELECT [nome_campo] FROM [SISTEMA_AS400]
..[SCHEMA_AS400].[UTENTE_AS400].[NOME TABELLA].[NOME CAMPO].

When I run this query I obtain only some records, not all.
How can I do to obtain all records ?

The query in DTS will be the exact same as you use to query the AS400
directly so whatever you would use to retrieve all rows there is what
you will use in DTS.

Have you tried to narrow down exactly what "subset" DTS is giving you?
Maybe that will help you to identify why the rows are not the whole
table.

Allan


"lfrance" <lfrance (AT) discussions (DOT) microsoft.com> wrote