• Heh... they won't allow you to use xp_CmdShell because they think it's a security risk (it's patently NOT when used correctly) but they will let you call a C# script from SSIS?  Fascinating.

    Perhaps you can do it through the command line and still be compliant with their (mostly incorrect) perception of security.  Please see the following article with the understanding that I do use xp_CmdShell for such things and so haven't actually tried to do what you ask from SSIS.
    https://sqlserverrider.wordpress.com/2013/01/03/executing-msdos-commands-in-ssis/

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