Tilde Delimited Imports

[PPSPeare]

Hello Folks,

I'm not a super SQL person I know basics around SQL version 7. Here's the problem. Our old server is slowly dying and we're trying to convert from SQL version 7 to SQL version 5. The two versions of SQL are not on the same server. From my understanding any migration would require SQL 2005 to be installed on the same server as the older version but I'm not sure if I read things right. If that's not true how can I move our current DTS's from the older to the newer server?

If it is true that I can't migrate any of the DTS's with our current setup how can I create a job that will import a tilde delimited file into SQL. The only options available to me are the 'normal' delimiters like comma, tab, etc. Basically every row (which contains roughly 150 data points per record) is being read as one field and I can't separate them. I've tried a few things and nothing is helping me break up each line into the correct fields.