| Author |
Topic |
|
Zix
Starting Member
31 Posts |
 Posted - 2010-01-06 : 09:10:13
|
| Hi all. Returning to SQL Server after several years of not using it. So, sorry if my questions are off the wall. :)Project: Import data from an ftp site and dump it into a staging table. There are some other nuances, but this is the basic goal.Looks like SSIS can do all of this for me, but I'm running into a problem with the flat files. When I open them using an editor the data appears not to be delimited by anything. When I run the import wizard the data appears to map to rows/columns nicely. But, it's "jumbled". It's like what prints out when a print driver gets hosed.Could this be a driver issue? An encoding issue?Any thoughts?Thanks,Clay |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 09:42:52
|
| whats the format of flat file? how is this generated? |
 |
|
|
Zix
Starting Member
31 Posts |
Posted - 2010-01-06 : 10:01:14
|
| The format is .txt and I'm pretty sure the encoding is ANSI. It is generated by a third party. I assume they export it from their SQL Server environment.Is that what you are asking? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 10:07:05
|
| ok. what happens when you look at preview through oledb source in ssis? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-06 : 10:56:23
|
What are youre settings in wizard on that page in relation to the flat file?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Zix
Starting Member
31 Posts |
Posted - 2010-01-06 : 10:56:48
|
| Thought it would be easier to show you what I'm doing. Here is a video capture that I took since I'm not really sure how to describe what I'm seeing.<removing video link> |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-06 : 11:04:06
|
You have not considered all the possible settings after choosing the input file.Delimiter etc.maybe fixed?click on columns to set length of fields for example
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Zix
Starting Member
31 Posts |
Posted - 2010-01-06 : 12:40:58
|
| Yeah, I see. I thought this was 2 separate problems. I knew I needed to map the data fields and planned to do that later. Looks like manually mapping everything solves both problems.Thanks for the assist guys. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-06 : 12:42:32
|
welcome 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
Unexpeted Results when importing