Viewing 15 posts - 11,776 through 11,790 (of 13,870 total)
You have pretty much just repeated your initial post without providing the information requested by the respondents. Why should others make the effort to help you if you cannot be...
October 30, 2010 at 4:46 am
Several ways of doing this. One is to create a FEL that processes *.txt and then another that processes *.csv.
A data flow within each FEL takes care of the difference...
October 28, 2010 at 4:47 am
What I am unsure about is whether Excel interprets the string "20%" correctly as a numeric percentage and does the formatting for you.
If it does, you should add a derived...
October 28, 2010 at 4:04 am
Sujeet Pratap Singh (10/28/2010)
[font="Times New Roman"]Hi Phill,I thought you have got an answer !!! please share it if this is the case.
[/font]
Sorry - I'm in the middle of a course...
October 28, 2010 at 4:02 am
Why are you doing this? Is it because you want a numeric value formatted as % in Excel?
October 28, 2010 at 2:00 am
It's because they don't know how to use Access and Notepad is ungainly to use - understandable, I think. But we as IT people are in a position to educate.
October 26, 2010 at 8:47 am
Craig Farrell offered all the value I need with his public flogging. Made me laugh with a hangover this morning, and that's quite a feat 🙂
October 23, 2010 at 12:03 pm
I cannot help you because I still do not understand, I'm sorry.
You started the thread with a source table containing two fields:
Source table field (NAMEONE, NAMETWO) MAPPING WITH ONE destination...
October 22, 2010 at 12:59 am
You have managed to provide sample data without illuminating things much.
If your sample data is really
COLEMAN JEFFREY C & JENNIFER C/O J COLEMAN
how do you know where Nameone ends and...
October 21, 2010 at 7:25 am
Can you give maybe two or three examples of what NAMEONE and NAMETWO might contain and what you would like NAME to contain for each?
Regarding NameType - does that mean...
October 21, 2010 at 12:02 am
Can you side-step the problem by replacing commas in your header variables with some other character before they are output? Or by using a different column delimiter everywhere else (eg...
October 20, 2010 at 11:56 pm
Are you saying that your script task does not put the characters there but that something else does?
October 20, 2010 at 7:16 am
da-zero (10/20/2010)
Phil Parkin (10/20/2010)
Modify your script task slightly to not insert the final <CR><LF>? Or is that too obvious?
Relax. The week is almost in the middle. It is almost weekend...
October 20, 2010 at 1:06 am
Modify your script task slightly to not insert the final <CR><LF>? Or is that too obvious?
October 20, 2010 at 12:28 am
You cannot control mappings dynamically at run time in SSIS, using the built-in components.
If you have the money and inclination, this may work for you (I have not tried it...
October 20, 2010 at 12:24 am
Viewing 15 posts - 11,776 through 11,790 (of 13,870 total)