Insert/Update column value with special char #

[lpadrta]

I'm using the odbc connector to insert in a sql server table.

I'm trying to insert/update a varchar column with a value "#XYZ" and it is making the target column blank/empty.

Have a suggest on how to get the "#XYZ# inserted/updated in the target?

Thanks for your help!

Lynda

[chulett]

Which is it - "#XYZ" or "#XYZ#"? Asking since you posted both variations. If it is the latter then I'd guess it is thinking it is a job parameter that it cannot find... but that would leave it intact rather than null.

[lpadrta]

Oops, sorry.

There's only one # sign. #XYZ is the value I want to insert.

[chulett]

Really not sure why that value would be an issue... but then I have no direct SQL Server experience. Is that your only issue, meaning other values load correctly and just something that starts with a hash ends up null?

[lpadrta]

Wow. I've rerun the job while testing some other issues, and now the #XYZ values are loading OK. I'll have to investigate to find out if someone changed my source or the table or the DS environment. Sigh.

Thanks, chulett.

I'll report back if I can find a reason for the change. Even if it's a ID10T UE.

Lynda

[chulett]