I have a comment field with data or no data. The problem
is when I transfer the data into AS400 if field is empty
it translates to end of record, however in reality it is
not. How do I fix this issue?

And the Source is?

If it is a text file then can you not wrap strings with "" and then your
import should see this as an empty string?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


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