Post reply

Problem loading a file FTPed from Mainframes into SQL Server table using SSIS

  • December 10, 2008 at 6:24 am

    #383548

    Hi,

    I am facing a problem while loading a file that was FTPed from Mainframes.

    Following is the sample content from the file:

    1 EBM 20081209 3394

    2 056902232 EDCNO

    3 EBM 20081209 3394008942

    When I try to load the file into the table using Flat File Connection Manager, I don't get any data after the numbers. This is what I get in the table:

    1

    2

    3

    When I open the file and make a small change like adding a space, delete the space again and save the file, all the data gets loaded into the table properly. I am not understanding the logic behind this.

    I have tried options like adding a space using the Script task, copying the file to a new file. None works.

    I can send out the file that I have got from the Mainframes if anyone is interested.

    Please help me out.

    Thanks,

    Chaitanya

  • January 2, 2009 at 11:05 am

    #920447

    Can you view the file using some kind of binary viewer? It sounds like there is a null character (ascii 0) after the numbers.

    Russel Loski, MCSE Business Intelligence, Data Platform

  • January 2, 2009 at 5:10 pm

    #920610

    If there's nothing in the file that violates either privacy or policy, my recommendation would be to attach the file to a post and let us take a crack at it for you. Of course, a record layout description would be much appreciated, as well.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply