JoMar
asked on
copy a file using ssis and sql jobs
I have created an ssis package and then modified it to add a file task at the end. The file task replaces a file in a mapped directory on a different server. When I execute the package in Visual Studio it works fine, then when I import the new package into ssis and execute it it works fine. I created a sql job to run the new package and when I run it, the file is created in the target folder, however, the file does not copy to the other directory. Is there something special I need to put into the sql job to make the copy part work? Thanks in advance for any help.
JoMar
JoMar
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please ensure the NT account you will be using in the proxy has sufficient permisions at OS level and folders to perform all tasks as the user running it when the copy succeds - check the connection manager for the step that " file task to copy the file to a mapped directory, it also replaces the file in the mapped folder."
ASKER
the proxy server issue was stopping me from copying, however, i put the .bat file into a sql job using a cmd line and it is working now. Thanks for the help
ASKER
This is not a command shell. After the file is created, i inserted a file task to copy the file to a mapped directory, it also replaces the file in the mapped folder. When I execute the package on as an ssis package, the file is created in the target folder and the file on the mapped drive gets replaced. When I create a job to run the ssis package, and execute the job, it runs and creates the file on the target drive, however, it doesn't seem to do the copying step. I will try to create the proxy as you suggested and see if that works.