We recently purchased the SQL agent for MSSQL db's (we already had the SQL agent for Oracle). I have a user now asking about support for SSIS (SQL server integration services). I honestly have no idea. I'm the UC4 Administrator - I install the agent, I get it functional and know how to create a job that uses it and connects to an MSSQL db, but beyond that - not really my area of expertise.
Is anyone familiar with SSIS and can explain what it is and/or how (or even if) it integrates or can be used with the MSSQL agent?
Thanks guys. The people involved managed to figure it out. They are running SSIS packages from a SQL job.
Thank you for the explanations. Every little bit helps.
I know exactly how you feel. I've recently become the point of contact for our Automic instances, but have a long way to go to reach the same level of comprehension as the previous individual.
To your question, I will second what Matthew stated. We have several teams that leverage a Windows agent to execute SSIS packages from the command line, using dtexec. My understanding is that these packages can be created/exported from MS SQL Server. So far I've not heard/seen anyone directly executing ssis packages from Automic (without dtexec in the middle) with SQL agent. Hope this helps!