We have an issue where we need to monitor a log file for an error code. I thought there may be a way to do this in SSIS where it can read a line in a file? I have seen an article about reading the SQL Error Log file but not specifically any file.
In SSIS add a Script Task component.
The Script Task component facilitates writing VB.net or C# code
In the Script Task, for your situation, you could write C# code that uses the .Net StreamReader
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…