Is SQLXML Bulkload 64-Bit compatible?

Id like to use SQLXML Bulkload on a 64-bit Win2K3 and SQL Enterprise
64-bit setup. Has anyone tried this yet? Im assuming it wont work.
Heres some background...
The production servers were upgraded to 64-bit a year ago and are
working great.
End user analysts approve and submit their updates via an Excel file.
Tho old 32-bit process used OPENROWSETs Jet provider to read the
Excel file into a SQL table. I think I could get the end users to
save-as XML from Excel, but the resulting file is much larger than
8000 characters and needs to be loaded into 64-bit SQL.
Our current workaround is to use an old 32-bit server to read the xls
file into SQL, then BCP it out, then transfer the text file to the
64-bit server, then BCP it in to SQL 64-bit. its a manual process.
we could automate that, but it would still involve a 32-bit server
which is not part of our production farm.
Rather than add a 32-bit server to simply import from a Excel or XML
file, wed like to find a full 64-bit solution.
Thanks,
Ray Metz
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/XML-SQL-Bulk...ict231047.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=799881
You could try and use 32-bit SQLXML Bulkload in a 64 bit machine through the
WOW option.
SQLXML 4.0 that will be shipping with Yukon is supported on 64bit.
Chandra
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"RayMetz100" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_799881_4ee33ff366c068b445b3350611cd84d3@.dbf orumz.com...
> I'd like to use SQLXML Bulkload on a 64-bit Win2K3 and SQL Enterprise
> 64-bit setup. Has anyone tried this yet? I'm assuming it won't work.
> Here's some background...
> The production servers were upgraded to 64-bit a year ago and are
> working great.
> End user analysts approve and submit their updates via an Excel file.
> Tho old 32-bit process used OPENROWSET's Jet provider to read the
> Excel file into a SQL table. I think I could get the end users to
> save-as XML from Excel, but the resulting file is much larger than
> 8000 characters and needs to be loaded into 64-bit SQL.
> Our current workaround is to use an old 32-bit server to read the xls
> file into SQL, then BCP it out, then transfer the text file to the
> 64-bit server, then BCP it in to SQL 64-bit. it's a manual process.
> we could automate that, but it would still involve a 32-bit server
> which is not part of our production farm.
> Rather than add a 32-bit server to simply import from a Excel or XML
> file, we'd like to find a full 64-bit solution.
>
> Thanks,
> Ray Metz
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/XML-SQL-Bulk...ict231047.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=799881