i need to make a project to move data from 1 table in one server to another server. I have used the export tool in MS SQL, if i could save this and reuse the credentials and the selection query that would be a great solution. I just need to change a few parameters each time i move the data. Perhaps SSIS is where this project needs to go.
January 6, 2018
I am looking for a mix of experience and value