Sorting files in a process files step
We are trying to use a Process Files step to read in a directory of SQL scripts and then pipe that to the Run SQL step in order to release to a database. The issue we are running into is the order of the scripts are being run in. We have tried naming our scripts so that when the order they are applied to the database is important with a convention of 001<ScriptName>, 002<ScriptName>, etc. It appears that the Process Files step is not sorting in any fashion. Is there a way that we can have these scripts sorted?
Thanks,
Tony C
|