Google ....

http://www.eps-publishing.com/Article.aspx?quickid=0301101

is this what you are after?

HTH

gah

Hi Steve

we have successfully installed 32-bit SQL 2005 (Std) side by side with 64-bit SQL on Win2008 64-bit.

We installed the 3rd pty ODBC driver using odbcad32.exe

I am new to SQL...

....update

have installed SQL2005 32-bit alongside exg 64-bit version

from SSMS i just want to run a simple data import using the 32-bit ODBC driver already installed.

When I right click a db...

That certainly is bad news.....but thanks anyway

to clarify...is that 32-bit SQL AND 32-bit OS ?

gah

to clarify...

bcp is quick, but I need a text file...yes?

(ie a table dump to text from the legacy system)

if this is the case, then I am stymied ....see above

Thanks for...

Terry, many thanks for your comments

what I have done so far is to truncate the tables, drop indexes, DTS in and recreate indexes.

this is marginally faster than loading with indexes...