Is it possible to import an incrementing file in SSIS using a different file name each day?
For example – on Monday I want to import “file1” on Tuesday I want to import “file” and so on.
This is so I can set a package up in SQL server to run everyday using a different file.
If not, are they are similar work arounds?
View Complete Post