[thelist] SQL Server: How Can I Convert VARCHAR to INT?

James Aylard webmaster at equilon-mrc.com
Mon Aug 20 13:20:43 CDT 2001


Rory,

> DTS in SQL >= 7.0 is graphical, and is simple, imho, to use, and provides
a
> great latitude of efficacy, which you seek.

    That sounds like an excellent suggestion, since transforming the data at
time of import would be the most efficient way to do it. I have never used
the GUI for DTS before (I didn't know that there was one until now!), but it
doesn't look too threatening.
    Thanks for the tip!

James Aylard





More information about the thelist mailing list