I am using MS Access as the front end (Microsoft Office 365 ProPlus) and currently have a SQL2008 server. I am migrating to a newer SQL 2014 server and are experiencing issues with code written using SQLDMO while testing in the new environment. I have an SSIS job that is called using the now deprecated SQLDMO that is obviously failing in the new environment. I am having limited success finding how to use SQLSMO in a similar fashion. Can someone please give some general direction (or specific!) so that the application can call these jobs in the new SQL server 2014?
Here is the code snippet we use:
Private Sub Command45_Click()
Set objSQL = CreateObject("SQLDMO.SQLServer")
' Leave as trusted connection
objSQL.LoginSecure = True
' Change to match the name of your SQL server
Set objJob = objSQL.JobServer
For Each job In objJob.Jobs
If InStr(1, job.Name, "SSIS Bills") > 0 Then
MsgBox "Job Started"
Thank you, and please let me know if I have failed to provide necessary information.