I have problem as follows: files comes from FTP and stored in share folder from share folder based on their types they are loaded into database. I am trying to use WMI event watcher task to know the information whether new file is placed is in shared folder or not, how to get output filenames from that wmi event watcher task.So that i can use file system task to put the files into other folder and later use data flow task for loading into database.
please help me how to get output filenames which are newly placed in the folder through WMI
I have done a project similar to this where I was 'watching' an FTP folder location for new files.
Most FTP sites I've used, if not all of them, are not windows boxes or if they are windows, wouldnt allow WMI access.
Two questions, are the filenames unique? And do you remove the downloaded files from the FTP site?
If each file is unique (you won't have to remove them), I created an ssis package which downloaded the files, then looped through the files in the folder, and loaded them into a table. Then I checked another table that holds the already uploaded files. If they haven’t been processed before, I load them using a dataflow task.
If the files are not unique, then you should download the file and remove it from the FTP site (remove it so whenever there is a file there, you know it is new) and rename it with a time stamp, then upload it.
Then you can schedule your package to run however often you like.
There are stacks of good SFTP addins here http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/00043b62-d243-427a-8118-3b40e9281050.
If you need any more help with this, then let me know and I’ll make steps for you.
Cheers and happy SSISing
answered Apr 19, 2010 at 09:00 PM
Was this resolved? I'd like ot see the solution as well.
answered Apr 14, 2011 at 08:43 AM