May 21, 2009 at 11:03 am
Having a bit of a problem here with the formatting of this flat file.
The table that everything is coming from has same lengths that will be used in the fixed length flat file.
Specs are that it's fixed length terminated with cr/lf. It also has to be in the ASCII character set and that one is giving me the biggest problem.
Are there any tricks to exporting it to ASCII?
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
May 21, 2009 at 11:15 am
How is your source data formatted? Is it Unicode or ASCII?
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
May 21, 2009 at 11:26 am
It's an OLE DB Source on a table. On the Data Flow Path Editor it's DT_STR.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
May 21, 2009 at 9:55 pm
Can you provide some sample data? If it's not ASCII, what is it?
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 22, 2009 at 1:10 pm
I finally figured it out. Data Conversion and 2 Derived Columns later and I'm good.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply