SSMS Auto Save – Recover Lost Files

Standard

Hi All,

I’m sure, many times you’ve all faced the frustration of losing your work due to an SSMS crash. The good news is that if you’re using SSMSBoost¬†your recent query windows will be saved.

If you go to the settings of SSMSBoost and check the Script Execution History tab, you’ll see there is a checkbox that will Enable Execution History, you can also choose where to store your files.

SSMSAutoRecover2.PNG

Extremely useful and this doesn’t require you to save every query window that you open!

Advertisements

SSIS -Registry setting specifying configuration file does not exist

Standard

I was having an issue getting an agent job from completing when running a package that relies upon an Indirect XML Configuration File. When executing the agent job I received a couple of warnings, one from the SSIS Package itself and another from the Event Viewer:

Event Viewer:

SSIS_EnvVar.png

SSIS catalogue error:

SSIS_EnvVar2.png

The problem here was that I had my environment variable used to specify the location of my config file set up in my User Variables and not in System Variables. This was also a problem because I’d specified the [NETWORK\SQLAgent] user as the SQL Agent service logon account.

SSIS_EnvVar3.png

Once I switched my variable into System Variables my agent job ran through without error.

SSIS – Keyword not supported: ‘provider’

Standard

Today I’d set up an agent job for a project deployment model SSIS package. In my project I’m using connection managers to handle my database connections and had configured my SSIS package to use the variables I wanted, however when I kicked off my agent job, it failed with this error:

Error: System.ArgumentException: Keyword not supported: 'provider'

SSISPackage_WrongConnectionType

Eventually I figured out that during configuration of my SSIS project I’d pointed an ADO connection in my SSIS package to an OLEDB connection manager in my environment variable. Once I swapped the connection to point to an ADO connection the package ran as expected.