Monitoring a folder for a file - start ssis

Hi

I want my package to monitor a directory for a file and when it detects one it will start processing the file. Any help would be appreciated

Regards

Ants

The only (and easy) idea that comes to my mind is to schedule the package to run n times a day and to include conditional logic in control flow based in the existence of files on the folder.

Rafael Salas

|||

You can use the WMI task to do this. There is a sample in BOL.

Or, you can download the fileWatcher Component. http://www.sqlis.com/default.aspx?23

|||WMI is a good option here and the WMI Watcher Task will help you to achieve the same.

I remember reading somewhere that the memory used by the package will

be released only when the package is stopped, so in your case if the

package is going to be waiting for the file (package in run state), we

need to consider the side effects of memory.

Thanks,

S Suresh

MOM 2005 Reporting error

Hi

I m using MOM 2005 SP1 FR with MSSQL 2000 SP3 and i get this error on one of my reports :

Erreur de Reporting Services
--
Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted) Obtenir de l'aide en ligne
Impossible de lire la ligne de donnes suivante pour le dataset PerfAnalysis. (rsErrorReadingNextDataRow) Obtenir de l'aide en ligne
La conversion d'un type de donnes CHAR en type DATETIME a donn une valeur hors des limites des valeurs de date et d'heure.

--
Microsoft Reporting Services

What can i do, i think i must edit xml file ?

Regards.

I have exactly the same problem !
Did anyone have an idea ?

Regards.