Extract SQL Queries from SSIS PACKAGE (.DTSX) FILES This Python script scrapes SQL queries from Data Flow and Execute SQL tasks inside of .dtsx files and writes them to SQL files in 'sql_scripts' ...

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to ...

The script SQL Backup and restore database in combination with this script can be a very powerful tool. In case a database needs to be migrated after an application update for example, it is often ...

I’ve posted the script above, along with the setup scripts on my GitHub. This includes creating a new database, scripting out all the tables into individual script files, and ensuring all the schemas ...