Post reply

Flat file source with empty last column

  • November 5, 2014 at 7:47 am

    #300919

    SSIS - 2008R2

    Multiple flat files in a directory

    So we loop through the files, but in all of the files the last column is blank - or it is so far.

    How do I get the flat file source task and flat file connection manager to cope with

    No text qualifiers, comma delimiters, and the last column potentially having no content for a file (it still has the header.

    So if the file format is

    EmployeeNumber

    EmployeeName

    EmployeeGrade

    then all the files have these columns as headers but if any files come in with blank last columns for the whole file (apart from the header row) then my package errors.

    Is there a fix for this so SSIS can understand the last column may be empty

    Cheers

    E

    😎

  • November 5, 2014 at 9:13 am

    #1756768

    Can you post an example of what you mean by empty last Column?

    Is it something like this?

    Column1,Column2,Column3

    1,Something,

    2,Sometext,

    Or like this?

    Column1,Column2,Column3

    1,Something

    2,Sometext

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • November 5, 2014 at 9:40 am

    #1756776

    Its like like this?

    Column1,Column2,Column3

    1,Something

    2,Sometext

    I have bodged it by opening up the CSV and placing a blank space after the last comma. It seems to be comma and then end of line that causes the issue.

    Cheers

    E

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

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