dbTalk Databases Forums  

Bulk Export Task collation problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Bulk Export Task collation problem in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tomer Shoval
 
Posts: n/a

Default Bulk Export Task collation problem - 03-27-2006 , 11:47 PM






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?


Reply With Quote
  #2  
Old   
Satya SKJ
 
Posts: n/a

Default RE: Bulk Export Task collation problem - 03-29-2006 , 08:52 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\SYSTEM\CurrentControlSet\Contro l\Nls\CodePage
--
-----------------
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on
Performance topic.


"Tomer Shoval" wrote:

Quote:
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?



Reply With Quote
  #3  
Old   
Tomer Shoval
 
Posts: n/a

Default Re: Bulk Export Task collation problem - 03-29-2006 , 07:57 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?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.