Read TXT File - problem with importing from flat file source ssis

  • jaryszek - Wednesday, November 29, 2017 7:41 AM

    Thank you Guys,

    i used :

    Select
    *,
    CAST(Company_NIP as float) as Company_NIP2
    FROM QlikView.dbo.tbl_Slownik

    and there is NO any problems within this.
    I am shocked. Wow! 

    Thank you!
    I am closing the topic but still not know why this was not working in SSIS...

    Jacek

    You are welcome!
    😎
    BTW, he he, SSIS "works" in misterious ways :w00t:

  • The original problem is caused by removal of the column definition to the left of Data_Zmiany. The column names presented when a file contains a header row and the "Column names in the first data row" is checked are only to help identify the field contents. I often rename them to the destination table column names which makes mapping from the data file to the database table automatic. When the rows following the header row are loaded, the relative position of the name is what is important. In this case anything in the second delimited column of the input file should be identified as Data_Zmiany. If only interested in the Data_Zmiany field then two columns must be identified - the UniqueID and Data_Zmiany which identifies Data_Zmiany as the contents of the second delimited field of each row. These fields could be called anything - IgnoreMe1 and Col2 - it does not matter.
    If you really wish to remove the first column from appearing in the following steps in the Data Flow, right click on the Flat File Source object and select "Show Advanced Editor...", select "Input and Output Properties", expand "Flat File Source Output" and "Output Columns", select each column that will not be used and click on Remove. This only eliminates the column from the output of the Flat File Source but not the column definition in the connection manager.
    Note that for a data file containing multiple delimited columns creating only one column name automatically turns off the column delimiter so all data in a row including the column delimiter will appear in the defined column (Visual Studio 2017). If only the first column was required two columns would still have to be defined.
    I find SSIS to be very useful and have used it to load billions of rows of data. For complex editing I add a Script Component C# routine.

  • Hi Dennis,

    thank you for your precious answer ! 

    It is working like a charm.
    Problem was also connected with nulls in my database within float field. 
    I bypass the problem replacing nulls with 0 in QlikView...

    Warm Regards,
    Jacek Antek

Viewing 3 posts - 16 through 17 (of 17 total)

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