DSXchange

It is using a DRS stage

We are running a job that moves data from one SQL Server database to another SQL Server database, performs a sum and then writes out a hash file. The Polish characters are written correctly on the 2 databases but not in the hash file. We are using NChar on all input and output tabs, locale is PL for...

Chars save some space but they should only be used for fixed length fields. Varchars are better for fields like names etc.

I would also like to join a Peoplesoft group if one ever gets set up

When I try to read a field with a NULL value from DB2 running on an AS400. The staging table which exists in SQL Server populates the field with garbage data, looks like a hex value. Has anyone experienced this before and what was their work around?