Posted by chudson007 on 03/13/06 14:59

Erland,

As I've never used PERL i'm trying to import the file to one column in
SQL using DTS.
I'm experiencing difficulty here too though....

The header row has a len of 143, and the records below can be much
longer.
The ipmort process is cutting the records after 143 characters, meaning
the whole file is not imported.
I've tried increasing the number of characters in the transform option
but it has not worked..

If you think using your PERL code is the best option, how to I get
started using PERL?
i.e. what software do i need to downlaod to drop you script into?

Any other suggestions that would help me are welcome.

Regards,
Ciarán

[Back to original message]