Underscores in column names disappear in script component
Hi,The column names I'm using often have underscores in them. I've noticed that, when writing script in the script component editor, the underscore characters mysteriously dissapear. Is this a known bug? (I can't find any reference to this by Googling)Thanks in advance,Lawrie.
June 3rd, 2006 11:37am
Probably a bug, but also might be by design depending on where the underscores are disappearing.
K
Free Windows Admin Tool Kit Click here and download it now
June 9th, 2006 12:27pm
Kirk,
Any underscore in a column name always disappears within the script component. Doesn't change the pipeline metadata of course and everything still works.
Having said that, I've never tried using a script component that had the following columns names:
Column1
Column_1
This could cause some problems!!!
-Jamie
June 12th, 2006 2:49pm
Having said that, I've never tried using a script component that had the following columns names:
Column1 Column_1
This could cause some problems!!!
It will fail in SSIS 2008 C#:
Error 1 The type 'Input0Buffer' already contains a definition for 'Column1'
Error 2 The type 'Input0Buffer' already contains a definition for 'Column1_IsNull'Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
April 26th, 2011 3:24pm