First make the SSIS package and then schedule it using sql agent job. If you can use the Devart Data flow components, then you can use Devart Postgresql destination to insert data into Postgresql table and can use an OLE Db source to read data from sql server. Once SSIS package is ready, you can schedule it using sql agent job th-cam.com/video/qrV2FbQpU3I/w-d-xo.html
@learnssis sir I have done the configuration and able to send data from mssql to Postgres but as soon as I am trying to schedule that job from SQL server agent it fails my package and getting an error..even I have tried you explained in a video to restart the service if job is failing,I have done that but then again job is failed and got the same error..I have tried every possible way like I have installed the ods driver of same configuration and I did the setting of system.dsn but again and again I am getting an error..please akil sir make a video and please once please send tha data from mssql to Postgres using job and scheduling...I am fully dependent on your lectures..🙏
Beautiful Explanation AQIL bhai Amazing dedication
Thank you.
First comment: Nice explanation
Thank you.
@akil sir please teach me how to send data from Mssql to Postgres using job and scheduling
First make the SSIS package and then schedule it using sql agent job.
If you can use the Devart Data flow components, then you can use Devart Postgresql destination to insert data into Postgresql table and can use an OLE Db source to read data from sql server.
Once SSIS package is ready, you can schedule it using sql agent job
th-cam.com/video/qrV2FbQpU3I/w-d-xo.html
@learnssis sir I have done the configuration and able to send data from mssql to Postgres but as soon as I am trying to schedule that job from SQL server agent it fails my package and getting an error..even I have tried you explained in a video to restart the service if job is failing,I have done that but then again job is failed and got the same error..I have tried every possible way like I have installed the ods driver of same configuration and I did the setting of system.dsn but again and again I am getting an error..please akil sir make a video and please once please send tha data from mssql to Postgres using job and scheduling...I am fully dependent on your lectures..🙏
@@abhinavkumar2662 What error are you getting?
Buenisimo, que version de visual studio estas usando??
Visual Studio 2019.