we are looking for a solution to copy/export the data daily/when needed from the local machine to the remote (server) database
we are using sql server 2005/2008. The script / ssis / DTS package should work with these.
We are getting some errors while trying to connect from the management studio.
You may have to use teamviewer and the like to diagnose and connect and fix the issues.
we can individually connect to both the local machine & the server and can insert into the server but not this export function from local machine to server
pls check the error msgs from the attached file.
19 freelancers are bidding on average $79 for this job
Hi aitinc, I am very experienced with SSIS, and confident that I can fix the problem for you. Few more questions need your help with, please check PMB. Sincerely yours, John
I can do what ever u need in plsql in sql server versions. I have 2.5 years of experiance in a complex sql project. Give me this project, sit back and see.