I've inherited a SQL Server box that I'm not an expert on. At the time I installed SSMS 2014 to keep an eye on the daily SSIS jobs that were running on it. I think because I'm an idiot and used the 2014 evaluation copy of SSMS, once that evaluation period stopped, the jobs stopped.
I have SSMS 2016 installed on the same machine. Is there a way to get the SSIS jobs running again if I just uninstall 2014 and use 2016 instead?
Executed as user: [*]. Microsoft (R) SQL Server Execute Package Utility Version 12.0.2000.8 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved.
Started: 8:00:00 AM
Error: 2017-04-03 08:00:00.76
Code: 0xC0000033
Source: *
Description:
Integration Services evaluation period has expired.
End ErrorError: 2017-04-03 08:00:00.76
Code: 0xC0000033
Source: ***
Description:
Integration Services evaluation period has expired.
End ErrorCould not execute package because of error 0xC0000033.
Started: 8:00:00 AM
Finished: 8:00:00 AM Elapsed: 0.187 seconds.
The command line parameters are invalid. The step failed.
For clarity, here's a rough chronology of events that's led up to here:
SSMS is a separate free product now, with monthly updates. Uninstall the old version, then download and install the latest one. The latest version at this point is 16.5.3.
Don't download 17.0 RC3, it's still missing some important features.
BTW SSIS jobs aren't executed by SSMS. They are executed by SQL Server Agent. Once you install SSMS 16.5.3 you need to check the job history to see why they stopped, what errors occured etc.
If there is a problem with the SSIS package, you'll have to check the package's Execution history. Open the Integration Services Catalog, find the package, right click on it and select Reports > All Executions
.
I'm still not totally clear what the issue was, but it's been resolved now. I went into my installation center of SQL Server 2014 and input a product key for it. After the upgrade, everything worked as expected.
User contributions licensed under CC BY-SA 3.0