SQL – Scripting out DB Mail Config with PowerShell and SMO
Quick Tip – Run SSIS 2012 packages synchronously and other execution parameters
Fellow MVP Jonathan Kehayias has a post on scripting out the Database Mail configuration with PowerShell and SMO. While this solution looks perfect, there is a bug in the Mail.Script() output, not mentioned in Jonathan’s post except for one reader’s comment, that does not script out the SMTP server name and port number. (Note, that […]
SQL Saturday #165 – Lincoln, NE
In the new SSIS 2012 catalog’s project deployment model, by default if you execute a package with the Execute Package control flow task, or through the new API’s start_execution, the call will be made asynchronously. In order to call the package synchronously, and therefore keep the caller waiting until the package finishes, you have to […]
SSIS 2012 – Beware the SSIS Server Maintenance Job
On Saturday, October 6th, 2012, please plan on attending SQL Saturday #165 in Lincoln, NE, at the University of Nebraska-Lincoln’s main campus. This SQL Saturday is shaping up to be a great event with several high-caliber speakers from around the Omaha/Lincoln area, as well as some from surrounding states. The event is hosted by the […]
SSIS 2012 – View Connection Manager Information for Past Executions
Those of you running SSIS 2012 may not yet be pushing the limits of the RTM release, and while I can’t tell you where the limit boundary lies, I can give you advanced notice about a fairly big problem. The entire SSISDB catalog is linked together via foreign keys, most of which are all linked […]
SQL Server 2012 CU2: New permissions for DBCC SHOW_STATISTICS.
There may come a time when you’re trying to troubleshoot a failed execution and you’re trying to determine what your dynamic connections were pointing to at the time of execution. Thankfully, this is quite easy with the SSIS Catalog in SQL Server 2012. Use the “more” link for the rest of the story.
Connecting to a pre-SQL 2012 SSIS Instance with SQL 2012 SSMS
Cumulative update #2 is now available for SQL Server 2012, and I’m happy to let you know that there is a very, very welcome change in database user rights. If you have SELECT permissions on a given table, you can now execute DBCC SHOW_STATISTICS to view the statistics histogram of any stats object on that […]
If you are using SQL Server Management Studio in SQL 2012 to try to connect to an older SSIS instance (SQL 2008 R2 and earlier) called “SSISServerName”, you will get an error: Connecting to the Integration Services service on the computer “SSISServerName” failed with the following error: “Class not registered”. This error can occur when […]