Text function not working in load script

[mstoler]

Hello,

I have an old script which uses the Text function to convert Periods (201601, etc) to text.

The script has been running for many years. I recently started testing with a new version of SQL Server 2014 and I notice when I apply the Text function to this field I get question marks or undefined values.

Is there an issue with the Text function and new versions of SQL Server or is there a SQL Server setting I need to change?

Thank You,

[Anil_Babu_Samineni]

I thought so they might change from Text to Convert

CONVERT(VARCHAR(19),GETDATE())

And can we know, Earlier which expression is working for you. So that, I may try same thing in 2014 and then we can discuss to solve the same issue

[marcus_sommer]

Normally a question mark is a placeholder for fieldvalues which hadn't a string-representation. If you used something like: num/date(Field) or dual(Field, Field) you will see the values. If this don't work please post your script.

- Marcus