Errors on importing a text file

When a DTS fails on a Text Source input with an error like "DTS_Transformation encountered an invalid data value for 'Column1' destination"

Is there a way to get the line number of the textfile where the import failed? It is hard to determine where in my 40,000-line file it found the invalid value for my column.

Thanks,
AndrewSpecify the LOG file in Package Properties/Logging.|||WHere does it store the logs on the server?|||Wherever you would like it to be.|||I set the error log file to a text file on my esktop - it seems to repeat the same error message (without the line number) - am i missing something?

Errors Importing From Enterprise Manager

Hi,
I am attempting to import objects from one database to another, including co
nstraints. However, the operation keeps failing. How do I find out the spe
cific reason for the failure? Enterprise Manager does not provide specifics
in the error message.
Thanks,
MarkIf you are using the wizard, you can find out more specifics by
double-clicking the line that says "error occurred"...
http://www.aspfaq.com/
(Reverse address to reply.)
"mark" <mark@.discussions.microsoft.com> wrote in message
news:4FE6D4E5-7285-4A01-927D-B47C4F4C3AE6@.microsoft.com...
> Hi,
> I am attempting to import objects from one database to another, including
> constraints. However, the operation keeps failing. How do I find out the
> specific reason for the failure? Enterprise Manager does not provide
> specifics in the error message.
> Thanks,
> Mark

Errors Importing From Enterprise Manager

Hi,
I am attempting to import objects from one database to another, including constraints. However, the operation keeps failing. How do I find out the specific reason for the failure? Enterprise Manager does not provide specifics in the error message.
Thanks,
Mark
If you are using the wizard, you can find out more specifics by
double-clicking the line that says "error occurred"...
http://www.aspfaq.com/
(Reverse address to reply.)
"mark" <mark@.discussions.microsoft.com> wrote in message
news:4FE6D4E5-7285-4A01-927D-B47C4F4C3AE6@.microsoft.com...
> Hi,
> I am attempting to import objects from one database to another, including
> constraints. However, the operation keeps failing. How do I find out the
> specific reason for the failure? Enterprise Manager does not provide
> specifics in the error message.
> Thanks,
> Mark

Errors Importing From Enterprise Manager

Hi,
I am attempting to import objects from one database to another, including constraints. However, the operation keeps failing. How do I find out the specific reason for the failure? Enterprise Manager does not provide specifics in the error message.
Thanks,
MarkIf you are using the wizard, you can find out more specifics by
double-clicking the line that says "error occurred"...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"mark" <mark@.discussions.microsoft.com> wrote in message
news:4FE6D4E5-7285-4A01-927D-B47C4F4C3AE6@.microsoft.com...
> Hi,
> I am attempting to import objects from one database to another, including
> constraints. However, the operation keeps failing. How do I find out the
> specific reason for the failure? Enterprise Manager does not provide
> specifics in the error message.
> Thanks,
> Mark