Hi to all,
i've a problem, legacy system (unix) send via connectDirect weekly to my file system where is mounted ms sql server 2000 extraction data files. This files are stored in AMERICAN_AMERICA.WE8ISO8859P15 really iso8859-15 format (Latin 9). I want to load in DB staging area correctly because data arrived from Poland, Italy, Turkey and Brazil and content descriptions in different language.
I think to use DTS and set in source text file all files, but i can't set codepage textfile to read correctly description and save on DB in nvarchar, ntext, ecc... (UTF-8)
Exists a solution like convert in Latin1 or set a codepage and collation on SQL server. Another problem is this data will be presented on web application in UTF-8.

Waiting your news