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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2008-01-15 : 20:27:34
|
| I'm new to SQL Sever 2005 and I'm trying to do what Informatica (Power Center - ETL) is trying does.I have created a work flow and it is scheduled to run at every night 1:00 AM .The process is to load a flat file (CRV.data) into the database from a shared location.The flat file is transfered from a 3rd party and once the file transfer is complete it will create a indicator file (0 byte eg: CRV.DONE file) which indicates the CRV.data transfer is complete.In my workflow I will be waiting for the CRV.DONE indicator file and once it is avaiable I will start loading the CRV.data and once the load is completed I will delete CRV.DONE file and be ready for the next day load.Please let me know if there is any way in SQL Server 2005 to achieve it.Thanks |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-01-16 : 10:23:43
|
| Might want to check this puppy... File Watcher Taskhttp://www.sqlis.com/23.aspx |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2008-01-16 : 20:06:32
|
| Thanks a lot.I had to download the ".msi" file from http://www.sqlis.com/23.aspx to get the file watcher task to run in the control flow |
|
|
|
govindts
Starting Member
33 Posts |
Posted - 2008-01-28 : 11:53:12
|
Dear sqllearner,I am looking the solution for the same kind of scenario. Did it work? My scenario here is, i wanted to check the specific excel file 24*7 and it the file is modified and then i wanted to do some other action.. I downloaded msi file from http://www.sqlis.com/23.aspx. Now i am not sure how i can proceed??? I am using SSIS tool and i dragged the WMI Event Watcher and placed in control flow. When i double click this event, i am not able see the screen which i see in http://www.sqlis.com/23.aspx. Any help....quote:
Originally posted by sqllearner
Thanks a lot.I had to download the ".msi" file from http://www.sqlis.com/23.aspx to get the file watcher task to run in the control flow
|
|
|
|
|
|
|
Event Wait