Post reply

Urgent SSIS Help

  • July 21, 2016 at 8:12 pm

    #328564

    Hi Guys,

    I am having a strange issue in my simple SSIS Package.

    1st Step:- From Reading three different Excel File (All three excel has different Layout) and going to same destination staging table

    2nd Step:- Source SQL (Staging Table) To Flat File Source

    Here I am SQL Source

    Select Field1,Field2,Field3 from Excel_Source1

    union all

    Select Field1,Field2,Field3 from Excel_Source2

    union all

    Select Field1,Field2,Field3 from Excel_Source1

    Here is my Question and Problem:- Until Step 1st Count looks good and data looks good. On the 2nd step, Some time numbers are off 10 or 5 or 4. However when I check on

    Preview on 2nd Step Number Looks good but Number are missing when Package runs. I am not using only one transformation "Data Conversion" and I am not Ignoring any

    Error.

    Please advise I am SO confused and scared because this package will run on Production every 5 Minutes and We can't afford to loose any data from a raw file.

    Sometimes it is working fine and sometimes don't.

    Please advise. Thanks in advance.

  • July 22, 2016 at 2:19 am

    #1891506

    Does your Excel Source ignore conversion errors on any of these fields which aren't coming through? If so, try turning it off and seeing if it errors. It might be that some of the fields you have SSIS is seeing as the field as a type different to what would be expected (for example, a field containiing " 5" [Note the leading space], may be read as a string rather than a integer and so would error).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • July 22, 2016 at 7:49 am

    #1891566

    Thanks Thom for your reply.

    I am sure I am not Ignoring any errors.

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

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