Post reply

SSIS Delete rows in EXCEL workbook

  • February 7, 2017 at 8:41 am

    #326820

    I am trying to process files that I receive through email, I have them being saved in a directory, I can manually delete totals rows for each vendor. I've attached a image to show the data that needs deleted.

  • February 7, 2017 at 9:31 am

    #1927122

    Use a conditional split and only add an output for the rows you actually want to process.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • February 7, 2017 at 9:48 am

    #1927129

    Can you give an example?

  • February 7, 2017 at 10:14 am

    #1927140

    SSIS Conditional Split Example

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • February 7, 2017 at 10:19 am

    #1927143

    You're funny

  • February 7, 2017 at 10:30 am

    #1927147

    cbrammer1219 - Tuesday, February 7, 2017 10:19 AM

    You're funny

    This is a free forum and we are all volunteers here.  Most of us are more than happy to help when people are stuck on an issue, but we do like to see that they have made some effort.  Asking for an example 17 minutes after I posted my response shows that you did not put any effort into this.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • February 7, 2017 at 10:37 am

    #1927149

    If I hadn't looked up different ways to do it, I wouldn't have posted to here in the first place. These are always the type of responses I see and get. This site hasn't ever really been beneficial other than  the training, and the stairway, the forums never. Nothing but a bunch of smart%$# or rude posts, but that's cool.

Viewing 7 posts - 1 through 7 (of 7 total)

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