May 12, 2010 at 4:05 am
Hi,
I have flat file, derived column and OLE DB in my Data flow task. It executed successfully. But when i see the data in my table there are some spaces in one of my last column. For ex
1,Name1,End of shift [See space after End of shift]
2.Name2,Break [See space after Break]
I use TRIM function in my derived column. Even after that i won't affect. Still the spaces are there in my table.
Here my question is, how can i trim the spaces in the last column of the text file?
---
May 12, 2010 at 4:21 am
What is the data type of the destination column?
Can you be a bit clearer with your example? Are you saying that
'End of shift'
is being saved as
'End of shift '
?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 12, 2010 at 4:26 am
Its varchar data type.
There are the spaces in the flat file itself. I need to remove the space while inserting into the table. Usually, the text files are generated by reporting person.
May 12, 2010 at 4:44 am
"...spaces in the flat file itself..." I do not understand exactly what you mean. You did not answer my question about 'End of Shift'. Please provide accurate sample data.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 12, 2010 at 8:07 am
Double click on file connetion manager. click on columns.
Check the row delimiter = {CR}{LF}
and column delimiter = Comma(,) --- Looks like already exists.
Also check the field in General tab.
If didnt work then re-create the file. 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply