I created a job that read the data(probably certain millions) from csv file, do some transformations and insert the resulted rows into 2 MSsql tables(based on some conditions).
What is the best plan to deploy a similar job:
- deploy the job on server containing the Microsoft SQL server
- deploy the job on the server containing the csv files
