• There are several ways to get values into variables within SSIS. You can populate variables with return values from SPs, full ADO datasets, Filenames from a for-each-file operation, expression builder, script task, etc.

    What is it specifically that you are trying to do?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden