Est. Budget: $5.00
C# SSIS Script needed to read scripts files from a folder and create final Excel spreadsheet output. The purpose of the SSIS Package is to read the MSSQL script and determine all the database objects being used inside the script and what action is being performed on the database object.
Database objects mean: tables, queries, stored procedures
Actions mean: Select , Insert, Delete, Update, Exec
The output should be a Excel sheet showing the object name and the action being performed ...