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
Insert/Update column value with special char #
Moderators: chulett, rschirm, roy
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.
Last edited by chulett on Mon Dec 30, 2013 5:19 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
Thanks, chulett.
I'll report back if I can find a reason for the change. Even if it's a ID10T UE.
Lynda