Post reply

SSIS 2008 - renaming files

  • April 29, 2013 at 10:28 am

    #273380

    Hi,

    I have placed a file system task inside foreach loop container and the operator is rename file. I'm wondering if it's possible to find all files (regardless of file extensions) that contain "circle" and then replace it with "square"? If so, how I can accomplish this?

    Thanks!

  • April 29, 2013 at 12:44 pm

    #1610952

    I can't help here because I don't use SSIS. A thoughtful but simple DOS "rename" would do this, though.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • April 29, 2013 at 9:47 pm

    #1611091

    Jeff Moden (4/29/2013)

    I can't help here because I don't use SSIS. A thoughtful but simple DOS "rename" would do this, though.

    This solution would work and anything you can run in command prompt, you can also run in SQL using xp_cmdshell (http://msdn.microsoft.com/en-us/library/ms175046.aspx), which has security risks. But, if you are willing to overlook the risks, you can put this in an SSIS package.

    --------
    For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
    You can also follow my twitter account to get daily updates: @BLantz2455

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

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