The customer uses SQL Server as a data mart table. Only two columns are nullable and they aren't in the F&R Key. I think they use SQL Server bulk load libraries to populate it. If they don't update all these columns they get error due to key column being empty. I am wondering if MS puts in ascii 255 in the column??
CUST_NUM = ' '
CUST_NUM = ' ';
They load the table with this statement
FROM '<<Drive Number>>:\<<DIR FOLDER>>\<<FILE_NAME>>.txt'
FIRSTROW = 1,
FIELDTERMINATOR = '|',
ROWTERMINATOR = '|\n',
ERRORFILE = '<<Drive Number>>:\<<DIR FOLDER>>\<<FILE_NAME>>_Error.csv',
Release : 4.7
Component : CA Test Data Manager