copy a file using ssis and sql jobs
Posted on 2011-03-25
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.