September 17, 2007 at 8:02 am
I am building a package for pulling in data from multiple flat files and doing some comparisons, calculations, etc. Here is my problem, I import data from one flat file into a table. One of the columns is computer names. In the data there are all sorts of garbage in front of the computer name. I am new at this, is there some way in IS to read through the data and get rid of the garbage? What I was thinking was looking for the name of the computer and deleting everything in front of the that. Is that possible to do? Any other suggestions?
September 18, 2007 at 4:48 am
You can use a dirived column and substring. What defines garbage? How will you recognise a compute name in the string?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply