Home Forums SQL Server 2008 SQL Server 2008 - General is there a way to skip or ignore unwanted files? RE: is there a way to skip or ignore unwanted files?

  • 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