Post reply

is there a way to skip or ignore unwanted files?

  • April 15, 2013 at 1:30 pm

    #273599

    I want to skip or ignore those files that have a "unmatching" pattern in them (i.e, a_unmatched_b.xlsx, b_c_unmatched.xlsx, and so on). Is it possible to do this in SSIS?

  • April 15, 2013 at 2:53 pm

    #1606623

    kpann (4/15/2013)

    I want to skip or ignore those files that have a "unmatching" pattern in them (i.e, a_unmatched_b.xlsx, b_c_unmatched.xlsx, and so on). Is it possible to do this in SSIS?

    Hi

    Yes it is possible.

    I'd first match those with *unmatched* in the name and change their extensions to "xls" for example, and then filter out all other with extension "xlsx".

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com

  • April 16, 2013 at 9:55 am

    #1606889

    If you are looping through a folder using a for each container you could use a script task to check for the substring and set an appropriate condition for whether to process or not in a connector if you didnt want to alter filenames.

    'Only he who wanders finds new paths'

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

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