Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    1

    Unanswered: Unexpected Results when Importing Flat Files

    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

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    If you're using flat files then take a look at BCP: bcp Utility
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by Zix View Post
    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
    tab delimited perhaps ? did you get the file from an FTP server ? perhaps you did bin vs. ascii or vice/versa when retrieving the file ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •