Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kcaxd39
Starting Member
4 Posts |
 Posted - 2008-03-06 : 17:07:42
|
| I am new to SSIS and I am trying to do following thing using WMI Reader Task.I have developed SSIS package which import data from flat files.Now I have to add following functionality to SSIS package Before SSIS package load data I would like to check If there are all files in source folder and check the files are with current date.If both condition true then only load data.After some research i found that WMI uses specialized query language known as WQL, which is similar to SQL, to obtain information on files and directories.Also i found that Under WMI Reader Task editor properties you can write WQL query to receive file information from source folder.Can Anyone suggest me What WQL query i have to write to retrive file information from Source folder?Or Any Other suggesion i should approach?Please advise me!...Any help would really appriciated... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-07 : 03:50:29
|
| No idea about WMI reader but i think your requirement can be achieveved by the use of normal for each loop container using for each file enumerator and pointing it to your folder.You may use expressions to perform validations and use expression & constraint option of work flow to perform the conditional transfer. |
 |
|
|
|
|
|
How to read file information from source folder!