Home > Archive > MS SQL Server DTS > March 2006 > Bulk Export Task collation problem









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Bulk Export Task collation problem
Tomer Shoval

2006-03-28, 3:28 am

Hi Darren,
We're trying to use the Bulk Export Task from sqldts.com

in the log i get:
::Error::
[Microsoft][ODBC SQL Server Driver][SQL Server]Code page 862 is not
supported by SQL Server
[Microsoft][ODBC SQL Server Driver]Unable to resolve column level
collations


Is there anything i can do about it?

Satya SKJ

2006-03-29, 9:29 am

One of the links on web refers:
You could try another codepage (1255?).

You could look in the machine's registry to see what codepages it has
registered support for:

HKEY_LOCAL_MACHINE\S
YSTEM\CurrentControl
Set\Control\Nls\Code
Page
--
-----------------
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on
Performance topic.


"Tomer Shoval" wrote:

> Hi Darren,
> We're trying to use the Bulk Export Task from sqldts.com
>
> in the log i get:
> ::Error::
> [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 862 is not
> supported by SQL Server
> [Microsoft][ODBC SQL Server Driver]Unable to resolve column level
> collations
>
>
> Is there anything i can do about it?
>
>

Tomer Shoval

2006-03-29, 8:27 pm

under this registry key there are like a hundred values or so.
1255 is there.

what do you mean by "try another codepage"? How can i set the code page
in the bulk export task?

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com