Very Computer

I am attempting to import a datafeed file into a MSSQL 7.0 database.
The file was exported from Oracle (not sure which version) as a fixed
width text file.  The block size(row width) of the records in the text
file is 5610.  When I am defining the columns during the import I
cannot define a column past position 4096 in MSSQL 7.0.  Is there any
way around this limitation?

Adam

Adam - do you have SP1 applied?  Can't remember if this one is fixed in SP1 or
the (as yet un-released) SP2.

Quote:> I am attempting to import a datafeed file into a MSSQL 7.0 database.
> The file was exported from Oracle (not sure which version) as a fixed
> width text file.  The block size(row width) of the records in the text
> file is 5610.  When I am defining the columns during the import I
> cannot define a column past position 4096 in MSSQL 7.0.  Is there any
> way around this limitation?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (356 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.swynk.com/faq/sql/sqlserverfaq.asp
 or http://www.sql-server.co.uk

Neil,

No SP1 and I didn't see a fix for the problem in its fixlist, but I'll
try applying it and see what happens.

Do you know when SP2 is coming out or where I can find a tenative
fixlist for it?

Thanks,

Adam

On Sun, 31 Oct 1999 11:39:44 GMT, Neil Pike

Adam - there are a lot more fixes in SP1 than the fix-list lists.

Quote:> No SP1 and I didn't see a fix for the problem in its fixlist, but I'll
> try applying it and see what happens.

I don't know a date for SP2, but I'd say it's at least 6 weeks out as it hasn't
entered beta yet.

Quote:> Do you know when SP2 is coming out or where I can find a tenative
> fixlist for it?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (356 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.swynk.com/faq/sql/sqlserverfaq.asp
 or http://www.sql-server.co.uk