1. sureshv New Member

   if the incoming data is a flat file source and destination is to sql server 2005 database.
   The column data from flat file is uniccode string and if it has to transfer to a column of datatype int in the database.
   How can it be done????
   because at my final destination it shows error.
   
   
   

   sureshv, Mar 13, 2007

   #2
2. satya Moderator

   See this bloghttp://blogs.msdn.com/sqlprogrammability/archive/2006/07/07/659375.aspx on unicode conversion gotchas.
   
   Satya SKJ
   Microsoft SQL Server MVP
   Writer, Contributing Editor & Moderator
   http://www.SQL-Server-Performance.Com
   This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

   satya, Apr 1, 2007

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in