• Hi All,

    I got a requirement to load 40+ flat files in staging table along with file date and file name for each file.I could use for each loop to load the files at a time but confused about using variables in script task and also to get two extra columns in a table

    1.For file modified date

    2.For file name.

    Can anyone help with detail steps to achieve this.

    Thanks.