Hi,
We have 8 SSIS jobs which need to be made dependent on the arrival of a single file.
All the flows need to be triggered based on the presence of a file
Whats the way to do this
Thanks
Manish
SSIS EVent driven query
Hot Topic
- How can we write C# code in sql.
- Triggering an event when viewing a report
- SQLXML Client Features
- Performance counter on Report.
- SQL Server 2005 Workgroup Edition -- import/export question
- SqlDeveloper/SqlExpress Conflict.
- Does SQL Server support all languages using Unicode
- How to access data in resultset returned in variable by ExecuteSQLTask
- SSIS Package Corruption
- saving DTS package to sql server
SQL Server
- Automatic synchronization of lookup columns
- Problem using SQL Server Mobile 2005 with Windows Mobile 5 application
- Inconsistent Errors Using Bulk Insert with a Format File
- SQL 2005 Enterprise June CTP Installation Error
- Type 1 Dimension Insert/Update
- Reporting on Active Directory
- Error in the encryption library
- how to set the default filename when exporting the report
- C# CLR best practice example
- Sort on group total: How?
SSIS EVent driven query
Brainwav
You couldI would use the FileWatcher Task to watch for the file. When it arrives, use Execute Package Task to fire off your 8 packages.
To be honest, it depends on you. Do you want SSIS to watch for the files or do you want to control this from an external process
-Jamie