• ZZartin - Monday, April 23, 2018 3:31 PM

    Why are you doing this in SSIS at all, this can be done in one line in powershell as simply as

    Move-Item "C:\Test\input.txt" ("C:\Test\input" + (Get-Date -UFormat %b-%Y) + ".txt")

    And yes I would also recommend not using that date format, YYYY-MM works a lot better.

    I don't know PowerShell worth a hoot but that UFormat string looks like it might be for the MMM-yyyy format.  What's the format for YYYY-MM?

    --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)