Re: SSIS

2021-06-29 Thread Neeku Endhuku Nenu cheppanu
Thank you very much for your help Daniel... On Tue, 29 Jun, 2021, 9:18 pm Daniel Standish, wrote: > Here: > > from contextlib import closing > > from airflow.models.baseoperator import BaseOperator > from airflow.providers.odbc.hooks.odbc import OdbcHook > > > class SqlAgentOperator(BaseOperato

Re: SSIS

2021-06-29 Thread Daniel Standish
Here: from contextlib import closing from airflow.models.baseoperator import BaseOperator from airflow.providers.odbc.hooks.odbc import OdbcHook class SqlAgentOperator(BaseOperator): def __init__(self, job_name: str, **kwargs): super().__init__(**kwargs) self.job_name = job_

Re: SSIS

2021-06-29 Thread Neeku Endhuku Nenu cheppanu
8:32 pm Daniel Standish, wrote: > As others have suggested, using airflow to orchestrate stored procs > directly (or to build sql statements and execute them) is a nice pattern > that you could use to ultimately get rid of SSIS. > > However if you have legacy jobs that need to stay

Re: SSIS

2021-06-29 Thread Daniel Standish
As others have suggested, using airflow to orchestrate stored procs directly (or to build sql statements and execute them) is a nice pattern that you could use to ultimately get rid of SSIS. However if you have legacy jobs that need to stay running as is, and you just want to orchestrate them

Re: SSIS

2021-06-29 Thread Constance Martineau
Hi Neeku, I used to work in an environment that heavily relied on MSSQL Server and SSIS. Among other things, we used Airflow to orchestrate the SSIS jobs when moving to Airflow. While there is no specific "SSIS" package, assuming you are using odbc drivers, there is an odbc provid

Re: SSIS

2021-06-29 Thread Neeku Endhuku Nenu cheppanu
Thank you for your response... On Tue, 29 Jun, 2021, 2:17 pm Jarek Potiuk, wrote: > I think there are no ready operators for SSIS. You can build your own (and > contribute them back maybe) - it's actually not that difficult if you have > a Python API, or some command line interf

Re: SSIS

2021-06-29 Thread Jarek Potiuk
I think there are no ready operators for SSIS. You can build your own (and contribute them back maybe) - it's actually not that difficult if you have a Python API, or some command line interface (which you can invoke via Bash Operator for example). I might be biased, and I do not know much

Re: SSIS

2021-06-29 Thread Neeku Endhuku Nenu cheppanu
Thank you for your response. SSIS - SQL server integration services.. We are trying to schedule these SSIS jobs in Airflow... We don't find any article about this... Is it possible to schedule these SSIS jobs in Airflow?? Please help me out.. Many Thanks, Krishna v. On Tue, 29 Jun,

Re: SSIS

2021-06-29 Thread Ash Berlin-Taylor
What is SSIS? What have you tried already? What error are your getting? -ash On 29 June 2021 09:02:43 BST, Neeku Endhuku Nenu cheppanu wrote: >Please help me out on this.. > >On Thu, 24 Jun, 2021, 4:13 pm Neeku Endhuku Nenu cheppanu, < >idk.050...@gmail.com> wrote: > &g

Re: SSIS

2021-06-29 Thread Neeku Endhuku Nenu cheppanu
Please help me out on this.. On Thu, 24 Jun, 2021, 4:13 pm Neeku Endhuku Nenu cheppanu, < idk.050...@gmail.com> wrote: > Hi team, > > Is it possible to schedule a SSIS package's in Airflow?? > > Please let me know, if it possible... > > > Many thanks, > Krishna v. >

Re: SSIS

2021-06-24 Thread Neeku Endhuku Nenu cheppanu
Hi team, Is it possible to schedule a SSIS package's in Airflow?? Please let me know, if it possible... Many thanks, Krishna v.