"Ram" <ramraya@yahoo.com> wrote in message
news:6c89aae8.0401211018.7e30d146@posting.google.com...
> We are trying to load text tab delimited files into SQL server using
> informatica 5.1 version. The text files are FTPed to a local server
> and then files are moved to applicable folder before loading.
>
> The problem is when we open the files after FTP the characters are
> already converted to something else. EX: ü got converted as Ï.
>
> Now when we load them into SQL server we want Ï to transfer as ü
> again.
>
> In informatica we use relational database connection and specify SQL
> server as server type, there is no place where you can specify the
> character conversion parameter.
>
> Can anybody help solving this problem ?
>
> Thanks in advance.
> Ram.

> I'm not sure I understand completely - are you saying that after you FTP the
> file to the server's filesystem, but before loading it into MSSQL, the
> characters have changed? If so, then you would have to look into how it's
> FTPd, are there different Windows code pages on the servers, is the source
> system a different OS etc. If the characters change when loaded into MSSQL,
> then you would start by looking at the data types of the destination
> columns, and the collation of the database.
>
> Simon

"Ram" <ramraya@yahoo.com> wrote in message
news:6c89aae8.0401220715.603d6267@posting.google.com...
> > I'm not sure I understand completely - are you saying that after you FTP
the
> > file to the server's filesystem, but before loading it into MSSQL, the
> > characters have changed? If so, then you would have to look into how
it's
> > FTPd, are there different Windows code pages on the servers, is the
source
> > system a different OS etc. If the characters change when loaded into
MSSQL,
> > then you would start by looking at the data types of the destination
> > columns, and the collation of the database.
> >
> > Simon
>
> Hi Simon,
>
> Thanks for your response, the text files are extracted from a server
> with Roman 8 code page and they tried to FTP the files in both binary
> and ASCII modes.
> After FTP the results were same in both cases meaning the characters
> looks exactly same when we open these text files with notepad.
>
> So the extract team said we have to do the conversion before loading
> into SQL server.
>
> I don't know if this makes any sense but only option for me is to
> convert them before loading.
>
> Thanks,
> Ram.

> We are trying to load text tab delimited files into SQL server using
> informatica 5.1 version. The text files are FTPed to a local server
> and then files are moved to applicable folder before loading.
>
> The problem is when we open the files after FTP the characters are
> already converted to something else. EX: ü got converted as Ï.
>
> Now when we load them into SQL server we want Ï to transfer as ü
> again.
>
> In informatica we use relational database connection and specify SQL
> server as server type, there is no place where you can specify the
> character conversion parameter.