Posted by Erland Sommarskog on 03/14/06 00:12

(chudson007@hotmail.com) writes:
> 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..

Unfortunately, I don't know DTS, so I can help with that part.

> 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?

Free download is on http://www.activestate.com/Products/ActivePerl/?mp=1.

Admittedly, Perl has bit of a learning curve, but once you know it, it's
a wonderful language to work with. There's plenty of books on the market.
Since I learnt Perl myself a long time ago, I cannot say which is the
best to start with today. It might be the so-called Lama book, "Learning
Perl" from O'Rielly.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]