i have an ssis package i designed in sql server 2008 business studio. it copies some data from one sql server to another that are hosted in a different location than this server. the job runs fine when i manually run it but i keep getting a login failed error when i try to run it in the sql server scheduled job. i need someone to resolve this asap since i am manually running this until i get it resolved.
14 pekerja bebas membida secara purata $65 untuk pekerjaan ini
I have years of experiences in SSIS and job scheduling. Have resolved the same issue in my current project. I will be able to provide you a very quick resolution of your issue.
Hello Mr. iwflceo, I can tweak your SSIS package to overcome this one. Any further queries on the workflow to solve this problem will be much appreciated. Thanks