Pete Carter questions

Pete Carter answers

• Pass SSIS variable to Process task
• SQL Server Partial Database Backup (excluding some tables)
• SSIS transaction management MSSQL
• Linked Server Insert-Select Performance
• Use SqlTransaction & IsolationLevel for lengthy read operation?
• What is the common sql for sysdate and getdate()
• Where does SQL Server Agent save jobs?
• How to migrate DTS packages to SSIS 2012?
• Profiler in SQL Server 2012 Express [closed]
• Adventure Works Explanation