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.